Getting sheet name

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

How can i call the currently visable sheet name into my vb macro? I am
currently using a macro to create a invoice, what the macro is doing is
creating a new sheet and formating the sheet as required (with the layout
and everything). Everything on creation is working fine just i need a way of
identifying the sheet, is there a way i can get the vb to also change the
name of the sheet? Any comments would be helpfull.

Thanks
Jamie
 
Hi
to get the name:
activesheet.name

but you may also consider using an object variable:
Dim wks as worksheet
set wks = activesheet

To change the name
activesheet.name = "new name"

or with the object variable:
wks.name="new name"
 
Jamie,

ActiveSheet.Name

returns the sheet name.

Activesheet.Name = "NewName"

sets the name to NewName.

HTH,
Nikos
 
Jamie,

ActiveSheet.Name

returns the sheet name.

Activesheet.Name = "NewName"

sets the name to NewName.

HTH,
Nikos
 
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

is there a way to control the sheet name you add 3
switch to another worksheet, then return to original sheet 2
Problem in adding macro to ribbon through Add-in 7
Run macro from active workbook whose name keeps changing 20
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Re: Reference must be to a macro sheet? 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Run Macro on All Sheets Q 8

Back
Top