Excel VBA - go to cell problem

From: Numan (Numan.1b31p0_at_excelforum-nospam.com)
Date: 08/16/04


Date: Mon, 16 Aug 2004 08:11:26 -0500

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/