I have a multi page spreadsheet, and I would like to have the macro record an
area that changes its number of rows constantly.

What I am getting back in the macro is an specific range of cells from the
table array sheet no matter how many rows it contains, and I use the END DOWN
to assign the range.

The lookup value on the main page records as END+DOWN, but seems to not
carry this feature to the other pages in the workbook.

Am using winXP with Office 2003.