Dear Sirs,
I need a Macro to do like this.
I am having a workbook containing up to 1500 worksheets. In this workbook, few worksheets (up to 100 sheets) are to be identified or selected and in these sheets certain bottom rows are to be deleted.
The sheet names shall be mentioned in the First worksheet in Column A and the row number or name (starting dell name of the row, which are different in each sheet) from where the rows to be deleted to underneath shall be mentioned in Column B against each sheet name mentioned in Column A.
Thanks Regards
VENU
I need a Macro to do like this.
I am having a workbook containing up to 1500 worksheets. In this workbook, few worksheets (up to 100 sheets) are to be identified or selected and in these sheets certain bottom rows are to be deleted.
The sheet names shall be mentioned in the First worksheet in Column A and the row number or name (starting dell name of the row, which are different in each sheet) from where the rows to be deleted to underneath shall be mentioned in Column B against each sheet name mentioned in Column A.
Thanks Regards
VENU