Emergency ( Adding Worksheets dynamically in Workbookds)

  • Thread starter Thread starter Ussiddiqui
  • Start date Start date
U

Ussiddiqui

Hi, i am in a hurrey, how to add worksheets dynamically in Excel Work
Books , i want to know this thing that how to do that with the help of
Code.
 
Just in case you want to add a name to your worksheet

Worksheets.Add
ActiveSheet.Name = ("whatever")


Rocke
 
or even:
i = Worksheets.count + 1
sName = "Sheet" & i
Worksheets.Add(after:=Worksheets(Worksheets.Count)).Name = sName
 
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

Prevent Excel crash when running 1
Testing dynamic range for values 3
auto insert worksheet name in dynamic named range 3
Combine 2 columns in a dynamic range into one 7
Dynamic add formula 2
vba dynamic 1
How to change add-in object from within worksheet module. 3
Dynamic worksheet selection using messagebox 3

Back
Top