Select all not working while selecting All Sheets using excel VBS

I m creating a VBS that converts all the excel formulas into values
(i.e. Select All Sheets>> Select All Cells >> Copy>> Paste Special>> Values//Using VBS)

I am almost close to it but there is some issue with my code may be.

Please Login or Register  to view this content.

Everything is working fine but the issue is Select all cells is not working properly.

This command is selecting All cells depending on the content in the first sheet.

For example if there is data in Sheet1 from A1 to B7 ten all the other sheets will be getting effect in cells A1 to B7

Actually select all code(i.e objWorkbook.ActiveSheet.Cells.Select) should Select All "A" to "XFD" Columns

but it is not working.

Kindly help me to solve this issue.

Originally Posted by LokeshKumar

Hi,

Don't use this

Please Login or Register  to view this content.

Use this

Please Login or Register  to view this content.

Hay... Its Working.....
Thank you so much

Please mark this thread as solved.