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
|