Hi Mike
I have try
Range(Sheets("Celler").Range("A1").Value).Select
or
Sheets("Celler").Range("A1").Value.Select

But i dosn't works
If i use
myValue = Sheets("Celler").Range("A1").Value

How shal i then use myVakue

regards
Alvin


"Mike H" skrev:

Hi Alvin,

Try

myValue = Sheets("Celler").Range("A1").Value

Mike

"alvin Kuiper" wrote:

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