Automatic print area & Sort filter

[Pisky]

Hi there,

I am wanting to have a VBA code that has a button I can press, which will automatically sort Column "A" to remove all blank lines,
then that also selects data from column A-K and down to the last row with data in it and prints that selection (These vary week to week with how much data is in the selection. One week could be 20 rows, the next 100)

I need this to happen for 7 different sheets all sorted and printed.

Is this something that can be done? I know I used to have a checklist with a VBA code that would change the dates and print off a each new page for the month with a click of a button.

Note** I cannot install XL2BB due to company restriction so have posted a screenshot.

 

[Fluff]

Duplicate to: VBA Code to Remove Blanks and Print the sheet?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.