I have a sheet called "Middle Sheet". In cell C1 I have the name of a
person. All other sheet's names in the workbook are a person's name. What I
would like is to take the name in C1 and put it into some sort of variable.
Then take that variable and open the sheet. So I can copy data into the
sheet.
thanks,
kyle

"Harald Staff" wrote:

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