From: Raj on 23 Feb 2010 11:13 On Feb 23, 3:33 pm, OssieMac <Ossie...(a)discussions.microsoft.com> wrote: > It is difficult to advise you without actually seeing what you want to > achieve. > > Suggest you experiment with Fit to Page in Page Setup. If you set to 1 page > wide and delete the value in Tall (leave blank) then it prints to one page > wide by how ever many high is required. > > I am sure you can record the code to get the correct syntax for your VBA code. > > -- > Regards, > > OssieMac Thanks for the Fit to Page solution. It worked. Regards, Raj
First
|
Prev
|
Pages: 1 2 Prev: one workbook, multiple users.... (Share workbook) Next: ComboBox Dropdown not under control |