Re: Excel VBA - go to cell problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Rech (jrrech_at_hotmail.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 09:47:49 -0400

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 >" <<Numan.1b31p0@excelforum-nospam.com> wrote in message 
news:Numan.1b31p0@excelforum-nospam.com...
| 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