Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use excel to insert data at the bottom of existing data
I have several csv files that i need to import into excel, one below the
other, on one worksheet. The length of the csv files vary, so i can't put an absolute value in my macro. Is there a way to automatically position my insertion point below the last row of data? The macro works great so far as the length of my csv files don't vary. But they do. Any ideas? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use excel to insert data at the bottom of existing data
set rng = cells(rows.count,1).End(xlup)(2)
rng is a reference to the cell where you import the next file. -- Regards, Tom Ogilvy "Mike Lines" <Mike wrote in message ... I have several csv files that i need to import into excel, one below the other, on one worksheet. The length of the csv files vary, so i can't put an absolute value in my macro. Is there a way to automatically position my insertion point below the last row of data? The macro works great so far as the length of my csv files don't vary. But they do. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imported Data Not Replacing Existing Data - Excel 2007 | Excel Discussion (Misc queries) | |||
Insert New Data in Order on an Existing Chart | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) |