Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
Dear expert,
In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
File Page Setup Sheet, you can choose the Print Area here.
Does that help? Regards, Ryan--- -- RyGuy "Freshman" wrote: Dear expert, In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
Excel has no "rows to repeat at bottom".
You could place the contents of L1 & M1 in the Footer. Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("L1").Value _ & " " & .Range("M1").Value End With End Sub Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 23:38:03 -0700, Freshman wrote: Dear expert, In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
Hi 7227,
Thanks for your help. Regards. "ryguy7272" wrote: File Page Setup Sheet, you can choose the Print Area here. Does that help? Regards, Ryan--- -- RyGuy "Freshman" wrote: Dear expert, In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
Hi Gord,
Thanks for your code and it works well. Thanks again. "Gord Dibben" wrote: Excel has no "rows to repeat at bottom". You could place the contents of L1 & M1 in the Footer. Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("L1").Value _ & " " & .Range("M1").Value End With End Sub Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 23:38:03 -0700, Freshman wrote: Dear expert, In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print with cell value
Good to hear
Thanks for the feedback. Gord On Sat, 5 Apr 2008 22:59:00 -0700, Freshman wrote: Hi Gord, Thanks for your code and it works well. Thanks again. "Gord Dibben" wrote: Excel has no "rows to repeat at bottom". You could place the contents of L1 & M1 in the Footer. Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("L1").Value _ & " " & .Range("M1").Value End With End Sub Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 23:38:03 -0700, Freshman wrote: Dear expert, In a worksheet, is there a way whenever I print the contents of any parts, values of 2 fixed cells (say L1 & M1) will always be printed to the row two rows under the last printed row? Please advise. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does the cell data print ouside the cell (over the line) | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
Excel cell looks good in print preview but doesn't print??? | Excel Discussion (Misc queries) | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) |