LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default VBA to find the bottom of a sheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to find the bottom of a sheet [email protected] Excel Programming 0 June 26th 07 07:11 PM
Find the bottom cell that contains a specific val in a range? amit Excel Worksheet Functions 2 January 24th 07 05:23 PM
Find value in bottom cell in a column [email protected] Excel Programming 7 June 28th 06 07:46 PM
Code needed to find records from bottom up Andy Excel Discussion (Misc queries) 4 December 5th 05 03:27 AM
How can I find bottom row of a spreadsheet Robert Gillard Excel Discussion (Misc queries) 2 March 22nd 05 11:50 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"