CODEWITHSUNDEEP
excelvba
user1624926
user1624926

Reputation: 451

Replace data in one colums of a range

I have filtered a workbook and I need to replace all the data in Column A with "ISSUE". This appears to be simple enough and I sure it is as I can get it to work no problem when I have no filter on.

I have setup a dynamic range and used 'For each cell in DRange' but no joy.

Any suggestions or help would be greatly appreciated,

Thanks,

Ciaran

Upvotes: 0

Views: 276

Answers (1)

Peter L.
Peter L.

Reputation: 7304

Do the following:

  1. Apply filter as you wish.
  2. Select all the values in A you need to replace.
  3. Having selection applied, type "ISSUE", but press CTRL+ENTER instead of usual ENTER - this will autofill the whole selected range with typed value, and only FILTERED values.

Upvotes: 4

Related Questions