Here is my problem. I have 15 pages of data entry that
use cells B10-ck343 on each page. The cells are full of
vlookup's and equations if data is entered. I am trying
to write a macro that will copy only the rows I have
entered data into on the 15 pages unto 1 page for export
to access. the same number of rows will be on each page.
The problem is that I can not figure out how to copy and x
number of rows instead of the entire block. Right now I
only have data entered in rows 10-14 but copying the cells
with a [end][downarrow] picks up the blank formula rows as
well. HELP Please!

Chris