Macro to dynamically select a range of data

[Harax]

Hi!

Looking for some help automating data selection for printing.

Please excuse my terminology but I will try and explain the issue I am having.

I'm required to print Paper work which feeds off my main schedule sheet via pivot tables.

In the example attached I am looking to have a macro which with one click can select all data on the sheet starting with cell B6.

Frame Cutting List.png

The extent of the data often varies in both quantity of columns and quantity of rows, so I need it to dynamically select the area for printing which is the end purpose. There are usually 15+ sheets per work book that requires this.

----

Within the example attached I have 2 pivot tables on the 'Frame Cutting List' which normally I would manually select the area B6:K28.

Any help will be greatly appreciated.

[mjr veverka]

Try:

Please Login or Register  to view this content.