Hi,

I need to select all cells of an excel sheet in my Vbscript code using objSheet.getRange() method. Any idea about how can I do so? what will be the last column no. in this case?

Also, while using
objRange.HorizontalAlignment = xlLeft method, I am getting an error "Unable to set the HorizontalAlignment Property of the Range class"

Does anybody know why I am getting this error?
Any help appreciated..........

To select all cells in an excel sheet use this piece of code

 Worksheets("<worksheet_name>").Range("A1:IV65536") .Select