View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Active cell hunt

hi
"next blank Cell in column C". meaning that there are no blanks cell from C1
to the bottom of the collumn.
sub gotoCbottom()
Range("C1").End(xlDown).Offset(1, 0).Activate
end sub

Note: the Activecell is where ever the curser is. you don't "goto" the
activecell. you are already there.
Regards
FSt1

"Jock" wrote:

Hi,
If I use a macro (and button) to go from the current active cell (currently
C50) to a chart which is on row 500 or so, how can I use code (macro &
button) to go back up to the next blank cell in column C?

There may be an easier way to do this but the summary is to click a button
to go down to the chart and another button by the chart to go back up to the
next blank cell.

thanks,
--
Traa Dy Liooar

Jock