Subscript out of range error
The following line of code results "subscript out of range error" on some
machines (other pc-s work just fine with the same code). All computers have
Windows XP and Excel XP.
---
G = Workbooks("hex_ee_converter.xls").Worksheets("Main ").Range("A35").Value
---
The workbook hex_ee_converter.xls exists and is open when this error message
occurs. The worksheet Main also exists and is open. The cell A35 also exists
and contains value 2.
What should I do to get rid of this error message?
enz
|