Worksheet count

  • Thread starter Thread starter Murray
  • Start date Start date
M

Murray

Hi,
I have a school project to do where I must add a new worksheet.
Unfortunately I dont know too much VBA so maybe someone can help.

I tried something like this but it did not work

dim i as Integer

i = Worksheets(worksheets.count)
here is were I fail firstly

Thanks to anyone who can help

M
 
Murray,

Try something like

Worksheets.Add after:=Worksheets(Worksheets.Count)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top