Return name of current worksheet
Activesheet.Name = "Raw data"
--
__________________________________
HTH
Bob
"Newbie_nick" wrote in message
...
I have data in numerous CSV files, and when I open them in Excel, the
worksheet name is the same name of the CSV file. Since I have numerous
files
all with different names, I would like to write a macro to select the
current
sheet and rename it as something generic like "Raw data". I'm sure that
this
is an easy request, but I'm struggling with it!
thanks!
Nick
|