Hello All,

I wonder if you can help with this (probably simple) problem.


Each worksheet Im working on may have several hundred rows, though each
one a different number of rows.
Im compiling them all to one worksheet.

The columns used, however, are set. So I'm trying to make a macro to
Select all the columns but only as far down as the data goes.

I'll need a similar (probably) macro to search down in the "Combined"
worksheet, find the first free row and ValuePaste the data in there.

Ive got as far as realising it may be something to do with:

Range("A:M").Select
Range(Selection, Selection.End(xlDown)).Select

But thats as far as Ive got.

Any help much appreciated.

Thanks
Ed



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/