AnsweredAssumed Answered

How To Add an Excel Sheet after Last Sheet with VBA

Question asked by omar on Apr 2, 2015
Latest reply on Dec 3, 2015 by williamholdin
Hi everyone,

in excel i want to add a sheet after the last sheet using VBA, but i didn't manage to convert the following VBA code into VEE:

*Sheets.Add After:=Worksheets(Worksheets.Count)*

when i just use *Sheets.Add* it works, but this always add a sheet before the active sheet.

hope that someone can help me.