Thread: How do I change a variable name based on a sheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Avenger The Avenger is offline
external usenet poster
  
Posts: 1
Default How do I change a variable name based on a sheet name
For example, lets say I have a string variable named strSales, I want to
iterate through the sheets, so when I'm on sheet 1, it'll be strSales1, on
sheet 2 it'll be strSales2, etc.
Reply With QuoteReply With Quote