| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Store cell & workbook references, to retrieve later in Macro | Excel Programming | |||
| need macro to call a workbook w/o the actual name of the workbook | Excel Programming | |||
| Help:Running a macro in one excel workbook from another workbook | Setting up and Configuration of Excel | |||
| Code in one workbook to call code in another XL file | Excel Programming | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
Threaded Mode
