View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Couchman[_4_] Robert Couchman[_4_] is offline
external usenet poster
 
Posts: 64
Default printing problem

Hello,

The message board doesnt seem very busy today! feels like
friday!

anyway,

i have a problem with my printing command, i am trying to
set the printout so that the "fit to page" option can take
a variable from a textbox on a form.

i have the following:--

.FitToPagesWide = textbox1.value
.FitToPagesTall = textbox2.value

but it doesnt work, it says that it cant understand the
command (yes i am using a with command)

can anyone please help?

the original (and working) way for this code was:--

.FitToPagesWide = 1
.FitToPagesTall = 3

Thank you,

Robert Couchman
)