Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i need a few lines of code to determine the active rows in columns A and B
and copy from one work book to another. i kind of understand the loop, but not a lot. i need to select/copy the active cells in workbook one (always Columns A and B) and paste them in the next blank row in Column A/B of workbook two. i know that to find the next blank cell where to paste is the following: Range("A1").Select Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = True help would be appreciated, jatman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Range from Open Workbook to Active Workbook | Excel Programming | |||
copy value from active sheet to another workbook | New Users to Excel | |||
VB to copy a sheet to active workbook | Excel Programming | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Copy Modules from One workbook to Active Workbook | Excel Programming |