Use a macro with this line
Application.Goto Sheets("Invoices").Range("G20"), True
--
Regards Ron de Bruin
http://www.rondebruin.nl
"JazzBlues" wrote in message ...
I would like to assign a macro to a forms button that, when clicked,
it will take me to a specific cell on a sheet called Invoices. I would
however like the cell that to which it takes me to be positioned in
the top left position on the sheet when I get there. If it helps I
have named each of the cells that i want the buttons to take me to.
the first button should take me to the named range "week1" and so on.
Any help with this would be appreciated. I know its a simple thing but
I cant get my head around this for some reason.
TIA
Dave