Code to Cover Non-Contiguous Columns

[cmpgeek]

Tommy - can you explain this coding to me a little bit? the spreadsheet that i mentioned where i wanted the code to work on the rows did not have columns that would need the code - just rows... would i then leave out the ranges where you listed column names and just leave the ones where the row names are listed?

thanks for your help...

Hi cmpgeek
Just saw that you also mentioned rows.
[VBA]

Dim rng As Range
Set rng = Union(Range("H:J"), Range("P:P"), Range("A:A"), Range("3:3"), Range("5:5"))
If Intersect(Target, rng) Is Nothing Then Exit Sub
MsgBox "Hit"
[/VBA]

BR
Tommy Bak