View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
enz[_2_] enz[_2_] is offline
external usenet poster
 
Posts: 2
Default 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