Delete columns based on cell value
Funny you say that J, that just what I did and for the same
reason :). Onece I got my code working with your help I step through
it and realized I was looking at every cell. And tried Dons code
On Jan 31, 10:27 pm, JLGWhiz
wrote:
You should take a good look at Don's suggested code. It does the same thing
that you are doing but is more efficient because it only uses the range where
you have data. Your code will chech all 256 cells of each row for each
iteration.
"Robert H" wrote:
thanks J, that fixed my code
On Jan 31, 5:32 pm, JLGWhiz wrote:
Try changing: Set curCell = Cells(1 & n)
To: Set curCell = Cells(1, n)
|