Selecting the first x visible rows of a filtered table

[DreamEyes]

Hi everyone,

I've been struggling with what I thought would be an easy problem.

I have a table with slicers to filter the data. I'd like to make a macro to:

- Ask user how many rows they want to copy from the table (variable x).
- Select the first x visible rows of the table (including the header)
- Copy the selected rows.

After searching for a while, I couldn't find a way to select the top x visible rows from my table.

Can I ask for your help please?

Thanks!

[xlnitwit]

Hi,

Perhaps this

Please Login or Register  to view this content.

[DreamEyes]

Perhaps I should replace the definition of Awesome with your name! The macro works perfectly fine, thank you very much!

[xlnitwit]

You're welcome. Please remember to mark the thread Solved.

[DreamEyes]

Done.

I'm sorry, I have an extra question if that's OK.
Would it be possible to select the table row minus the last column of the table?

The last column of the table is hidden but I realised that it's being copied as well. I tried to add an offset but to no avail.

Sorry for the hassle and thanks a lot for your help.

[xlnitwit]

A small change should fix that

Please Login or Register  to view this content.

[DreamEyes]

I like your magic. It works!
Many thanks!