set print selection cell based on criteria with vba

how to print out data based on criteria, example : see my attachment,

A1 to Q5 and A38 to Q40 always set as print area selections

i need vba script to solve it


thank you so much

guy i can use this function to filter data to be printed

Please Login or Register  to view this content.

but i want the function convert into vb code
thx for sharing

Hi Pakian,

Do you intend to print as you set the print area? - if so, then selectively hiding the rows not to be printed could be a solution. I'm experimenting with the issue

Originally Posted by xladept

Hi Pakian,

Do you intend to print as you set the print area? - if so, then selectively hiding the rows not to be printed could be a solution. I'm experimenting with the issue

selectively hiding more then 3000 row randomly, it takes long time , this function help me, i just filter with print to select print selection quickly, i put this function in column R

HTML Code: 

and now,,,how then the function putting in the modul as a vb code...?

I thought you only had 40 rows - but you can hide all the rows, then unhide the ones you want.

I've got this code but it won't give a cohesive printout!

Please Login or Register  to view this content.