Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a formatted worksheet with a 0.5" margin on the left and 0.25"
on top, bottom, and right. I am looking for a macro that after the user inputs whatever data into cells, the macro will find the bottom of the page and input some data into a cell. You might suggest just using a custom footer...I don't want that. Or you might suggest just having the macro designate putting the data into the cells at the bottom of the formatted sheet. The problem with this is that if there is no data on the sheet, the bottom of my page might be row 58. However, my cells are formatted to wrap text and if the cell requires wrapped text, that makes that row taller and subsequently will put my bottom of page row now at 56. So, if I designate to put text in row 58 and my other cell becomes larger due to text wrapping...and if I print...that gives me two sheets...one with my data and the other with my text at the top of sheet 2. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to find the bottom of a sheet | Excel Programming | |||
Find the bottom cell that contains a specific val in a range? | Excel Worksheet Functions | |||
Find value in bottom cell in a column | Excel Programming | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
How can I find bottom row of a spreadsheet | Excel Discussion (Misc queries) |