take Active Sheetname

  • Thread starter Thread starter Zurn
  • Start date Start date
Z

Zurn

Dim nameSheet as string

variable nameSheet has to be the name of the current sheet, what do
have to use
 
dim MyBook as string
dim MySheet as string

MyBook = ActiveWorkbook.Name
MySheet = ActiveSheet.Name
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print and save a single sheet from a workbook using a commandbutt. 1
Name Sheet with Input Box and text 2
Help in VBA. 5
worksheet renames - specific 0
Getting Value of Array element in Immediate Window 5
Automatically name all Sheet Tabs from a list 4
Using a variable to point to a location 2
Running an Access function (with parameters) from Excel 6

Back
Top