View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Creating Variable for a Sheet

Hi Kyle

If it's not the active sheet, how would the code recognize it ? Is there
anything unique in it ? And where is the macro, how is it started ?

Best wishes Harald

"kyle" skrev i melding
...
I have to copy data from one sheet to another. I am sending this program

for
others to use and I don't know what they will name the sheet. I have a

macro
that uses the ActiveSheet function right now, but I was hoping to get
something that is less sensitive and set up a variable for the entire

sheet.
Thanks,
Kyle Kyburz