Filling last column outside a current region

**Sudheerp** · 10-10-2007, 09:10 AM

I have the following code:

Please Login or Register  to view this content.

I want to edit the code so that the the Range("AG2:AH20000") will be instead:

Range("AG2:AH (Count of Column A rows)")

However I'm not so sure how to accomplish this, any help would be appreciated.

**VBA Noob** · 10-10-2007, 09:22 AM

Try

Please Login or Register  to view this content.

http://www.rondebruin.nl/last.htm

http://www.ozgrid.com/VBA/ExcelRanges.htm

VBA Noob

**Sudheerp** · 10-10-2007, 11:12 AM

You are pure genius!

**VBA Noob** · 10-10-2007, 11:15 AM

Glad it helped

Thx for the feedback....but no VBA genius. Still a VBA Noob

Leave the genius title to the like's of Leigh, Rylo and Roy

VBA Noob

Filling last column outside a current region

LinkBack

Thread Tools

Rate This Thread

Display

Filling last column outside a current region

Thank you!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions