Getting a Cell Value from another workbook
Will you please help me
I'm having a hard time declaring a variable from a cell value, from from another workbook. Dim iMax As Integer iMax = Cell.Value(workbook.["Plans.xls"].Sheet("Nov").Range("c1")) Thanks in advance |
Getting a Cell Value from another workbook
Dim iMax As Integer
iMax = Workbooks("Plans.xls").Worksheets("Nov").Range("c1 ").Value -- HTH RP (remove nothere from the email address if mailing direct) "techmoney" wrote in message m... Will you please help me I'm having a hard time declaring a variable from a cell value, from from another workbook. Dim iMax As Integer iMax = Cell.Value(workbook.["Plans.xls"].Sheet("Nov").Range("c1")) Thanks in advance |
All times are GMT +1. The time now is 12:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com