LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LizzyBorden1369
 
Posts: n/a
Default Finding Bottom of Sheet

Hi all,

I am trying to automatically copy a Range and paste this Range at the
Bottom in the destination. How do I find the bottom (after the last pasted
Range)? The Range size is a known constant. Within the Range, Columns and
Data are filled with combinations of Blanks, Text, and Numbers. I'm sure
this is an easy problem, but I new to VBA and just learning all the
methods/functions available. Thanks for the help.
 
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
data from one sheet to several in sequential order! firecord New Users to Excel 6 June 22nd 05 05:10 PM
Tabs accross of bottom of sheet are not showing robert Excel Discussion (Misc queries) 3 April 22nd 05 09:29 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 06:10 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"