Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell hunt
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell hunt
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
Setting up Treasure Hunt spreadsheet | Excel Discussion (Misc queries) | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
commandbar hunt | Excel Programming | |||
Code to Hunt Linked Cells | Excel Programming |