View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Select an empty cell

hi
try this...
Range("C6").end(xldown).offset(0,-1).select

regards
FSt1

"Patrick C. Simonds" wrote:

That does not move down to the first empty cell in column C.

"carlo" wrote in message
...
Something like that

cells(cells(6,3).end(xldown).row + 1, 2).select


On Jan 21, 1:39 pm, "Patrick C. Simonds"
wrote:
I need a piece of code which will look at column C and find the first
empty
cell in the column (must be below row 6) and then select the cell in
column
B of that row.