Don't set it to the worksheet name, set it to the worksheet object

Set sh = Worksheets("Sheet1")

...

TableDestination = sh.Range("A10").Value

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"marksince1984"
wrote in message
news:marksince1984.29b7yo_1150150204.0161@excelfor um-nospam.com...

I have a series of sheets with names set from variables.

I want to reference these sheets later in the macro to do other
functions

Eg

NewWorksheet.Name = variable1

...later in the macro

TableDestination:=variable1.Range("A10")

Will this work??

What is the best way to reference a variable as names??


--
marksince1984
------------------------------------------------------------------------
marksince1984's Profile:
http://www.excelforum.com/member.php...o&userid=33484
View this thread: http://www.excelforum.com/showthread...hreadid=551223