| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a Workbook based on a Cell information in another Workbook | Excel Worksheet Functions | |||
| linked workbook cell returns 0 is source workbook cell is blank? | Excel Worksheet Functions | |||
| Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
| pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
| automatically move cell data in 1 workbook to another workbook | Excel Worksheet Functions | |||
Linear Mode
