CODEWITHSUNDEEP
excelvba
abc
abc

Reputation: 429

Excel/VBA - How to make same edits to every existing cell in column

How do I add ="=" to every cell with values in a column? (example shown in pic). I read that this method will allow me to get exact matches when applying an advanced filter. I tried doing the AutoFill method (double clicking the square on bottom of highlighted cell) but it just replaces every cell in the column with the value in the first row. enter image description here

Upvotes: 0

Views: 128

Answers (1)

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 11978

This works for me:

enter image description here

="="""&A1&""""

Upvotes: 1

Related Questions