PDA

View Full Version : Add sheet after sheets count



YasserKhalil
07-13-2017, 11:22 PM
Hello everyone
I know how to add a sheet after sheets count but as for this line

With Sheets.Add.Cells(1).Resize(, 8)
How to add in the same line ... to be after sheets count?

I tried that line

With Sheets.Add.Cells(1).Resize(, 8)(After:=Sheets(Sheets.Count))
But it seems it doesn't work ..
Thanks advanced for help

YasserKhalil
07-13-2017, 11:24 PM
After posting the thread I tried that line

With Sheets.Add(After:=Sheets(Sheets.Count)).Cells(1).Resize(, 8)
And it worked well

Thanks a lot ...