Worksheet count

[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

 

[Chip Pearson]

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)