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