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 that finds the bottom of the 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
how can i see the headings at the bottom of the sheet sobhy New Users to Excel 1 July 30th 08 11:45 AM
VBA to find the bottom of a sheet [email protected] Excel Programming 1 June 27th 07 04:00 PM
VBA to find the bottom of a sheet [email protected] Excel Programming 0 June 26th 07 07:11 PM
bottom sheet tab disappears kaistix Excel Worksheet Functions 1 October 27th 06 07:14 PM
Calculate at the bottom of the sheet? AndyAnalyst Excel Discussion (Misc queries) 3 August 3rd 05 04:18 PM


All times are GMT +1. The time now is 08:33 PM.

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"