Excel VBA - go to cell problem
 

Hi all,

I need to pick some brains - the answer is probably so simple but I
keep on missing it.

What I am after is a piece of code that will allow me to press a
command button and then jump to a certain place on the excel
spreadsheet.

For example, I have 32 graphs on one worksheet and instead of getting
the user to scroll down all the time (half of the lot that I work for
wouldn't know what to do with a scroll mouse if it bit them!!) it would
be so much easier to have a button that said "Press here to go to next
graph".

I am absolutely stuck however on how to do it, as Murphy's law states -
I can remember the complicated stuff but the easy stuff escapes me!!

Please help.

Numan


---
Message posted from http://www.ExcelForum.com/

Excel VBA - go to cell problem
 

If you know the cell address where the chart begins your macro should do
something like this:

Application.Goto Range("A100"), True

--
Jim Rech
Excel MVP
"Numan " wrote in message
...
| Hi all,
|
| I need to pick some brains - the answer is probably so simple but I
| keep on missing it.
|
| What I am after is a piece of code that will allow me to press a
| command button and then jump to a certain place on the excel
| spreadsheet.
|
| For example, I have 32 graphs on one worksheet and instead of getting
| the user to scroll down all the time (half of the lot that I work for
| wouldn't know what to do with a scroll mouse if it bit them!!) it would
| be so much easier to have a button that said "Press here to go to next
| graph".
|
| I am absolutely stuck however on how to do it, as Murphy's law states -
| I can remember the complicated stuff but the easy stuff escapes me!!
|
| Please help.
|
| Numan
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|

Excel VBA - go to cell problem
 

Generally speaking this line will take the user to the
specified chart:

'Selects "Chart 30"
ActiveSheet.ChartObjects("Chart 30").Select

The charts are named in the order they were created.


-----Original Message-----
Hi all,

I need to pick some brains - the answer is probably so
simple but I
keep on missing it.

What I am after is a piece of code that will allow me to
press a
command button and then jump to a certain place on the
excel
spreadsheet.

For example, I have 32 graphs on one worksheet and
instead of getting
the user to scroll down all the time (half of the lot
that I work for
wouldn't know what to do with a scroll mouse if it bit
them!!) it would
be so much easier to have a button that said "Press here
to go to next
graph".

I am absolutely stuck however on how to do it, as
Murphy's law states -
I can remember the complicated stuff but the easy stuff
escapes me!!

Please help.

Numan


---
Message posted from http://www.ExcelForum.com/

.

Excel VBA - go to cell problem
 

Hi all

Thanks to everyone that answered this plea, I have now mastered 3 ne
ways of doing wnat I require.

Thanks all

Numan:

--
Message posted from http://www.ExcelForum.com