Selecting a Dynamic range within a Table

[Simon.Ward]

Hi,

My process is to find a column header value within a Table and then copy the used contents of that column to another sheet, i have the code to find the column header and then could just use

Please Login or Register  to view this content.

BUT the contents of the column may contain sporadic blank cells which would mean this piece of could would stop at the first blank cell and not copy the full contents, its also not very efficient to copy the entire column because of formula calculation time.

This was my code:

Please Login or Register  to view this content.

Then i tried this, but the Resize would not work with the "RowNumber", maybe because its within a table

Please Login or Register  to view this content.

I want to keep the range values as dynamic as possible because this is live data and can expand daily so i dont want to use set ranges

Let me know what i can do?

Many Thanks

SImon

[Simon.Ward]

Ok sorry it does work i just needed a 1 instead of 0 for the column resize

Please Login or Register  to view this content.