View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hayeso[_2_] Hayeso[_2_] is offline
external usenet poster
 
Posts: 2
Default Subscript out of range error

If you replace Range("A35") with Cells("A35) (or Cells
(1,35) then that should work.


-----Original Message-----
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


.