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.
|