Thread: Sheets reference change variable
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default Sheets reference change variable
wrote:
something like

sheets(range("A1").value).range....

would be what you want I think

Is it possible to have the sheets reference read the contents of a cell eg
Sheets(A1) where A1 contains JUN06 and would change if I altered A1 to
[quoted text clipped - 6 lines]

rest of macro etc


Wonderful, Thanks again

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1
Reply With QuoteReply With Quote