how to print label on the very end of excel sheet

[Guest]

Hi,
number of rows in my excel sheet varies.
How can I solve following:
I want label to be printed in the very end of sheet when printed (after the
last row)

Thanx
alekm

 

[Dave Peterson]

Kind of a "rows to repeat at bottom"???

Excel doesn't support this.

Can you use the Footer? File|page setup|header/footer tab

 

[Guest]

Can I make specific footer that shows itself only at the very end.
The thing is that I need label "Signature:______" that appears at the very
end but I don't know how many rows there will be before signature.
thanx

alekm

 

[swatsp0p]

You might try a macro with something like this...

First create a command button somewhere on your sheet (off to the side,
out of the way...)

Then assign this macro to the button:

Private Sub CommandButton1_Click()

Dim nLastRow As Long
' Find the last row of data in column A
nLastRow = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & nLastRow).Offset(2, 0).Select
ActiveCell.FormulaR1C1 = "Signature_______________________"
End Sub

-------
This will skip one row at the end of your data and insert your desired
formula in column 'A'. If you want it in Col.'B', the Offset should
read (2,1) {offset is Rows,Cols; a negative number would move up,left)

HTH

Bruce

 

[Dave Peterson]

Could you just put that at the bottom of the data? Maybe leave a couple of
empty rows, then add that text.

I'm not quite sure why you'd care how many rows are required--just include it at
the end.

This is not the same as file|page setup stuff.

(In fact, if your column widths make it look kind of ugly if you add it to the
bottom, maybe you could insert a textbox from the drawing toolbar and put that
at the bottom of your data.)

 

[Guest]

Thanx!

alekm