View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Robert H Robert H is offline
external usenet poster
 
Posts: 113
Default 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)