Sorry,
Workbooks("Database.xls").Worksheets......


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Rob van Gelder" wrote in message
news:...
As long as Database workbook is already open.

Workbooks("Database").Worksheets("Gate A").R .... etc..


If it's not already openthen you could use this:

Workbooks.Open ("C:\Database.xls")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Nic@Rolls-Royce " wrote
in
message ...
Hi

This is proberably v easy, however I can't figure it



I use a VBA macro to call up some infor and part of it is

Worksheets("Gate A").Rows("10:3000").EntireRow.Hidden = False
Worksheets("Question Database [Q]").Range("con_control").Copy
With Worksheets("Question Database [Q]")



"Gate A" & "Question Database" Are now held in a workbook called
'Database'

How do I amend the Macro to look at the sheet in the workbook rather
than the workbook it is in now???


Thankyou in advance

Nic


---
Message posted from http://www.ExcelForum.com/