| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy to Next Blank Row of Different Workbook
Hi
.... (the range will start at B4). I think I need xldown and right?! I would say that you'd better start from xldown towards xlup. Just because, if you go the other way round, if there is an empty cell in your range, this will be your last row and you just might half way to the last row... example of xlup dim lastr as long lastr = sheet1.cells(rows.count, 2).end(xlup).row the number 2 means column 2 or column B. Pascal Baro http://multiskillz.tekcities.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Hybrid Mode
