Hi
Can't you just record this using autofilter and set that to completet in column I, print and remove autofilter ???
regards Tommy
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?
Would be great, except that each sheet is being used by a spotty 15 year old, numnuts customer service agent, who thinks that VBA is some kind of sexually transmitted disease. The concept of logging off had to be explained to them 5 times, as when they were commanded to do it, 90% of them ran in the direction of the toilets.
I'm really going to need a big button for them to push that will do it all. Can anyone help?
By the way, I tried Tommy's suggestion and it didn't work. I dont know what's wrong with my system today!
Hi
Try this then. In basic it the same thing
Sub Makro1()
Range("A1").Select
Application.CutCopyMode = False
Selection.AutoFilter
Selection.AutoFilter Field:=9, Criteria1:="Completed"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter
End Sub
regards Tommy
This is REALLY annoying me now!! All day, people have been sending me really good code, and my stupid PC won't play any of them. It keeps throwing back a 1004 error 'method of Range Class Failed'
Can anyone tell me if there's a setting I should change to stop this happening. Do I have to change my references maybe?
My PC's monitor is sweating right now as it knows it only has a few more hours in which to do as I tell it before it learns to fly.
"3f9oijoiurgjv23`"
Oh, like that is it? Gonna start f@#king up my 5ords wh@n I tripe them a{e yo?
"iui weuif0-4-098rti0"
You're heading for a fall my lad
Audio> send me the workbook, if it's not to big for my k56 modem or to sensible, then I'll have a look at it.
(Before your computer learns to fly)
tommybak@netscape.net
Regards Tommy
Unfortunately, due to company privacy laws, I can't send any files out unless pre-approved. So I asked the manager and he said he'll get a "technician" out on Monday
Bad News: In reality, it'll be Tuesday
Good News: I get to scratch my a*se for 5 days
Thanks anyway for the offer man
Ok Audiojoe
then try to remove the first line of my code (range("A1").select),
select a cell i the data range and run it again.
Tommy
hi,
1004 errors are a pain in the proverbial...
I would suggest that a cold restart will help, I sometimes works for me.... usually better for the opperator i find!
otherwise the reference could be wrong, i assume you have the ms office object browser 9.0 selected, I really don't know why but mine keeps turning itself off and i get erroras like that..??
all the best and I hope that tues is a long itme in coming!!
Ed
Like this thread? Share it with others