Offset a selection

[morangeman]

I have solved a major issue with the following code which allows me to select the first 10 visible columns and down to the lastrow.

I need to run the code again but this time offset it by 10 columns to the right. The column reference will always change due to hidden columns but its position wont, it will always be the 11th column from the left.

Code:

Please Login or Register  to view this content.

What do i need to edit in the code to move the selection/print area over?

[morangeman]

bump no response

[FDibbins]

Please note that forum rules require you to wait at least 24 hours before bumping.

Also, some members focus on threads with zero replies - by bumping this thread, it now no longer has zero replies