Workbooks("mybook.xls").Worksheets("Sheet1").Range ("A1").Value = 100

HTH
--
Data Hog


"Robert Crandal" wrote:

VBA doesn't seem to like when I use the following code:

Workbooks("mybook").Sheet1.Range("A1").Value = 100

However, the code seems to work when I remove the part that says:

Workbooks("mybook").

How can I fix this reference so that I am able to use my VBA "Sheet1"
reference and specify the workbook at the same time?

thank u

.