Page Setup

  • Thread starter Alexander Bushan
  • Start date
A

Alexander Bushan

Just change this line
sRange = "A1:H" & iXrow
to:
Set sRange = objWS.Range("A1:H" & iXrow)
 
D

Dave Peterson

From VBA's immediate window:

?xlLandscape
2

objWS.PageSetup.Orientation = xlLandscape
would become
objWS.PageSetup.Orientation = 2

(What was iXrow equal to when you ran it the first time?)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page set up from VB6 1
How to Make Photo Inline? 0
How come VBA if clause fails? 10
Help with VBA runtime error 5
Excel VB to create and send an outlook appointment with html code 1
Range Resize property 7
type mismatch 1
Excel 2000 : Error 1004 1

Top