Select (from bottom) until Row 5

[FallingDown]

Hi all

I have a macro that I run everyday.
However, something bothers me, I need to manually deselect the four lines at the top as the should not be copied (but still are needed initially to support the user as references)

The data can have any lenght (200 rows, 1,576 rows, etc). But thats not the problem.
I'd like to know, whether it is possible to select all lines upto row 5 from the bottom
(There are several reasons why it cannot be done from the top to down without re-writing most of the macro)

Selection.End(xlUp).Select goes write to row 1

Thx
FD

[:) Sixthsense :)]

May be this...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[stojko89]

Where is your activecell when you run the macro. at the top of the column or bottom?

[FallingDown]

Hi Sixthsense

Your code almost works
I face the problem that the selection should only capture data tilll column "N"
Yours captures all, I tried to add "Range(Selection, Selection.End(xlToLeft)).Select", but it does not work (allthough I dont understand why)

[:) Sixthsense :)]

Thanks for your feedback.

Try this for partial selection

Please Login or Register  to view this content.

---

Sixthsense

[FallingDown]

Hi Sixthsense

Perfect!!
Thanks a lot