Thread: using variables to reference sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marksince1984[_5_] marksince1984[_5_] is offline
external usenet poster
  
Posts: 1
Default using variables to reference sheets

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

I want to reference these sheets later in the macro to do othe
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?

--
marksince198
-----------------------------------------------------------------------
marksince1984's Profile: http://www.excelforum.com/member.php...fo&userid=3348
View this thread: http://www.excelforum.com/showthread.php?threadid=55122

Reply With QuoteReply With Quote