I'd need to see a snippet of the loop you're currently in to see what variables you're working with. There should be a way depending on that. I know I make lots of loops with variables, and I am able to target certain columns and rows depending on where I am.
For example, I can use offset :
White Y = 1 to 200
If range("A1").Offset(X,Y) = "" then
range("A:A").offset(0,Y).Hidden = True
end if
Next Y
This is just an example of course. I use lots of Offsets and Range combo in my own scripts. There might be better or more efficient ways, but this has worked for me.
Bookmarks