Print Macro needed

  • Thread starter Thread starter Bob
  • Start date Start date
Have you tried the Macro Recorder (Tools>Macro>Record New Macro...)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I wanted a Row Column formula and you cant do that on record, I think!!

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
How about

Range("A1:H100").Printout

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
But I want to print (72,8) anywhere on my worksheet!

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Your sentences are very hard to make any sense out of. If someone really
wanted an answer, they would post a coherent message, rather than going back
and forth without providing useful details.
 
Bob,

but what is (72,8) a range, a number, a what?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks for the help I did manage to work it out!
ActiveCell.Resize(72, 8).Select

Selection.PrintOut Copies:=1, Collate:=True

End Sub

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Well, I don't think we would ever have guessed that from the OP

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top