hello
first of u go on print preview and setup then go to header & footer , select
page of 1 ? in header apply I think ur problem solved
On 9/25/08, pavithra murthy <[EMAIL PROTECTED]> wrote:
>
>
> hi
> i want the code for page numbers to appear on top of the print preview of
> my report on top o
u can use header or footer in print option
- Original Message -
From: pavithra murthy
To: excel-macros@googlegroups.com
Sent: Thursday, September 25, 2008 8:30 PM
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
hi
i want the code for page numbers to appear on top of the
Just Alter the loop body a bit, i.e. instead of saying Combo & I.value,
write it this way
Me.Controls("ComboBox" & I).AddItem Sheets(I).cells(Index,13).value
Ensure that the number of combobox controls on the form are within the
limits of the loop variable I. Me refers to the Form Object. If
Pavithra
Try this
under Headdeara and footers
Insert Page nomber and also pages
the symbol # and insert "/" and then click ++
it should appear like &[Page]/&[Pages]
Let me know if it works
Happy excelling
S Baloo
On Thu, Sep 25, 2008 at 9:00 PM, pavithra murthy <[EMAIL PROTECTED]>wrot
