YellowLabPro
04-07-2007, 06:49 PM
In this line of code, it targets column "D" or 4, can I specifiy another non-adjacent column in the same line w/out having to repeat the entire code for another column?
For Each c In Intersect(Ws.Columns(4), Ws.UsedRange)
ie.
For Each c In Intersect(Ws.Columns(4) & (23), Ws.UsedRange)
For Each c In Intersect(Ws.Columns(4), Ws.UsedRange)
ie.
For Each c In Intersect(Ws.Columns(4) & (23), Ws.UsedRange)