Macro to Print Select Rows

[Cardan]

Hello All,

I have a range of cells between A1:H70. Some of these rows have values, others do not.

In column “J” (J1:J70) I have identified the rows I would like to print with a formula that returns “p”. I believe any macro will have to effectively hide the rows that do not have a “p” in column J, print what is shown, and then unhide the hidden rows back to the original view. (If it is easier, I can denote the rows I do not want to print with a “x”). Unsure where to begin.

Any feedback helps. Thank you.

[Logit]

.
This is one way :

Please Login or Register  to view this content.

This approach does not require hiding any rows. It does require that you set aside one sheet to be used to copy the "P" rows to so they can be printed. The macro is setup for Sheet2 at this time but
you can edit that for any sheet you desire.

[jolivanes]

Please Login or Register  to view this content.

[myou]

Nice one jlivanes. I will try it as well.

[Logit]

.
jolivanes

VERY nice !

[Cardan]

This is a great, elegant solution! Thank you for the answer. I will mark this as solved. Thank you again!