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
|