Thread: How do I change a macro to call a sheet from another workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nic@Rolls-Royce[_7_] Nic@Rolls-Royce[_7_] is offline
external usenet poster
  
Posts: 1
Default How do I change a macro to call a sheet from another workbook
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 calle
'Database'

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


Thankyou in advance

Ni

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

Reply With QuoteReply With Quote