Thread: Goto
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alvin Kuiper alvin Kuiper is offline
external usenet poster
 
Posts: 175
Default Goto

Hi

I have a makro there get the user to a cell
Nomally i have
Range = ("A1").select

But now i want to get the value from another Sheet / Cell
i have trye with
Range = Sheets(Celler!A1).Select

But i dosn't work

What i want is to have a value in Sheets(Celler!A1)
and then use this value in a macro
so the user goto the value there are in Sheets(Celler!A1)
Not to Sheets(Celler!A1) but to the value there are in Sheets(Celler!A1)

Hope some one understand and can help

regards
alvin