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
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