Thread: How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lav Lav is offline
external usenet poster
  
Posts: 8
Default How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from?
E.g. The macro is in workbook1.xls

I wish to copy cell B2

So Activeworkbook.Select

Dim Workbook1

Set Workbook1 = Workbooks.Add (or is it Open?)("C:Workbook1.xls")

Workbook1.Activate

Range("B2").Copy

?
Reply With QuoteReply With Quote