VBA - Target Column by Name (not number)

[dellmech]

Right now, I have VBA code that only applies to the entire column B. So my VBA code says Target.Column = 2. I re-named column B "safe". I want my VBA code to always work even if columns are inserted between A and B. Otherwise, the code as it is will always just read column B and not follow the data when new columns get inserted. Any ideas?

 

[Fluff]

Assuming your header is in row 1 try

If Cells(1, Target.Column) = "Safe" Then

 

[hotabae]

I'm not sure how you are using Target right now, but in general, if you wanted to refer to a "named" column as a range, it would look like this:

Sheets("sheetname").Range("safe")

 

[dellmech]

Thank you!

 

[boiboi]

i got error app 1004 when used after For Each Cell In..

 

[Fluff]

Please start a thread of your own giving full details of the error & include you code.
thanks