View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default Advancing to the next cell

Hello all,

Is there a method (like the .SaveAs method) to advance the active cell to
the next unlocked cell? If so, when the active cell is in the last column
of unlocked cells for that row, will it advance to the first column of
unlocked cells for the next row?

I am hoping that there is a method that can be used. I can figure it out
using Range() or Cells() and doing a little math. But to use this way would
take some extra work like some rearanging of my worksheet.

Thanks for any help anyone can provide,

Conan Kelly