Greetings,

I have to prepare a report each week in which after compilation of all the
data I have to add one tab in each excel spreadsheet.
I have 15 sheets and all the sheets have different numbers of tab. I am
unable to conclude how to make macro to add a tab at the last of each
workbook.

Any help would be highly appreciated

Thanks
Dushyant

worksheets.Add after:=worksheets(worksheets.Count)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dushyant Rajput" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Greetings,
>
> I have to prepare a report each week in which after compilation of all the
> data I have to add one tab in each excel spreadsheet.
> I have 15 sheets and all the sheets have different numbers of tab. I am
> unable to conclude how to make macro to add a tab at the last of each
> workbook.
>
> Any help would be highly appreciated
>
> Thanks
> Dushyant
>
>