How about THIS for a request!

[Audiojoe]

What I need is a macro on a sheet, that will print all the rows. EXCEPT, that I only want it to print the rows that have the word 'Completed' in Column I.

These are few and far between so instead of having reams of paper, I need it so that when it prints out, all the selected rows are together if you know what I mean?

Is this going to be possible do you think, or is it too much to ask?

 

[Audiojoe]

I have 8.0 selected. I dont have 9.0 on this machine. Could that be it?

Tuesday WILL be a long time coming my friend, I have to go and pick some curtains with my better half tomorrow and that will make a day seem like a year

 

[Sbirro Cornuto]

Be sure to pick up nice ones!

 

[Audiojoe]

From my experience, I've found that the only way to enjoy curtain shopping is to get loaded on JD before you go. This turns a "Yes, they're lovely" into a "Oh yeah, they're f@@king beautiful. Ah, we got to have them sweetheart" whilst you hug the salesman for finding them for you

This also works for shoe shopping, clothes shopping and meeting in-laws