View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J_Knowles[_2_] J_Knowles[_2_] is offline
external usenet poster
 
Posts: 25
Default VBA worksheet references

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

.