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.



 'I am using following code to select all sheets
objWorkbook.Sheets.Select

'Using Following code to select all cells.
objWorkbook.ActiveSheet.Cells.Select

'Using Following code to Copy selected range
objWorkbook.ActiveSheet.UsedRange.copy

'Using Following code to Paste Values
objWorkbook.ActiveSheet.UsedRange.PasteSpecial -4163
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.