Setting Range based on LastCell

**matt4003** · 11-21-2008, 04:39 PM

Hello Again,

I am updating some code that allows me to ask users when they change a cell if they "are sure they want to make the change". Current code is posted below for your reference. I am interested in figuring out how to make a static range actually based on the LastCell.

See in the below code the rng is = to A8:BB50000. I would like it to be set for A8:LastCell

Please Login or Register  to view this content.

Below is the code in it's entirety.
Thanks for your help!

Cheers,
Matt

Please Login or Register  to view this content.

**royUK** · 11-21-2008, 04:48 PM

Try this

Please Login or Register  to view this content.

**matt4003** · 11-21-2008, 05:16 PM

Hello RoyUK,

Can you explain how this works?

Thanks,
Matt

**matt4003** · 11-21-2008, 05:27 PM

I can't get it to work...in fact now none of the original code works, even when I go back to the first static selection.

Weird.

**royUK** · 11-21-2008, 06:42 PM

The range is set to A1 to the last cell in BB

**matt4003** · 11-21-2008, 06:52 PM

Hello,

I don't know what the last cell is, or the last column, I need it to fingure that part out.

Perhaps I need to reset the last cell. I am pretty new to this. I just know I want my original code to be a little more dynamic so it doesn't try to execute for every cell changed...only those A8:LastRow and Row7:LastColumn. That would be the way to find the last cell, right??

Regards,
Matt

**royUK** · 11-21-2008, 07:16 PM

You had the range hard coded as "A7:BB5000", that's why I used that column. maybe
using UsedRange would be best.

Please Login or Register  to view this content.

Setting Range based on LastCell

LinkBack

Thread Tools

Rate This Thread

Display

Setting Range based on LastCell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions