Excel VBA - go to cell problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tod (todtown_at_swbell.net)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 06:53:57 -0700

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

'Selects "Chart 30"
Active***.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
>spread***.
>
>For example, I have 32 graphs on one work*** 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/
>
>.
>

Quantcast