Print Macro needed

[Bob]

Print (72,8)
--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Bob Phillips]

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)

 

[Bob]

I wanted a Row Column formula and you cant do that on record, I think!!

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

 

[Bob Phillips]

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)

 

[Bob]

But I want to print (72,8) anywhere on my worksheet!

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

 

[Dave R.]

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 Phillips]

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)

 

[Bob]

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
..
..
..
..

 

[Bob Phillips]

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)