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

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

Works a treat. Thanks
--
Traa Dy Liooar

Jock


"FSt1" wrote:

> 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