| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to Cells
I have two workbooks open in Excel 2003. From WorkbookA I need to get the
currrent row number, add 1 to it and copy the contents from WorkbookA to WorkbookB. Presently I have the following code that works... Dim CurrentRow as Integer Windows("workbooka.xls").Activate CurrentRow = ActiveCell.Row Range("a" & CurrentRow - 1).Select Selection.Copy Windows("workbookb.xls").Activate Range("D2").Select ActiveSheet.Paste When the .Activate is executed, workbooka is displayed, then workbookb is displayed when the second .Activate is executed...during that time it's flashing windows all over the place... my question: is there a way from workbookb to get the active row and cell contents from workbooka? this would eliminate the .Activates and appease my users... thanks in advance for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retaining formats when referring to cells | Excel Discussion (Misc queries) | |||
| Sort a list with cells referring to others cells | Excel Discussion (Misc queries) | |||
| copy & paste formulas while referring to same cells | Excel Discussion (Misc queries) | |||
| Referring to Cells in a forumula using a function | Excel Worksheet Functions | |||
| referring to other cells with formulas | Excel Worksheet Functions | |||
Threaded Mode
