Page Length

  • Thread starter Thread starter Ernie Moshurchak
  • Start date Start date
E

Ernie Moshurchak

I am trying to set up Excel to print a 5 1/2" continuous form
(length). Unfortunately the page size = statement is for a 5 1/2"
wide form (not length / height).

Just for fun I tried Word's PageHeight =
Application.InchesToPoints(5.5) setting but wasn't surprised when that
didn't work.

Excel is an excellent application for populating a form using
drop-down boxes, option buttons, etc. but unfortunately is not very
flexible in page setup options. It has been suggested that I use
Word's mailmerge function but I want to keep this application as
simple and easy to use as possible. I would appreciate any
suggestions or ideas anyone may have.

Ernie
 
Thanks Eddie. Your solution is something I never heard of... simple
and sweet! I'll give it a shot today and hopefully it will work.

Ernie
 
Implemented your solution today and it worked like a charm. On
researching the problem, I came across quite a number of requests for
help with similar problems including using Excel to print a continous
label. Hopefully these individuals will find this article if they
arre still having problems. Thanks again.

Ernie
 
Back
Top