ExcelBanter - Return name of current worksheet

hi,

On Error Resume Next
ActiveSheet.Name = "Raw data"

Mike

"Newbie_nick" wrote:

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