ADDING/DELETING SHEETS WITHOUT LOSING FOCUS.
Dim sh As Worksheet
Set sh = ActiveSheet
Worksheets.Add befo=Worksheets(1)
sh.Activate
--
__________________________________
HTH
Bob
"Faraz A. Qureshi" wrote in
message ...
I have a few sheets selected. How to have a new sheet be inserted at the
beginning, or deleting the first sheet, with the currently selected sheets
remaining to be selected.
A proper code for the same shall be obliged.
Thanx in advance.
--
Best Regards,
Faraz
|