Code Modification to alert 100% and over

**Preatorian** · 10-18-2009, 10:12 PM

http://www.excelforum.com/excel-prog...ml#post2175110
I was recently help with alerting in vba once a value of 100% was reached. This code works great and does what it is supposed to do.

I've tried to change it to use on another sheet to alert the value of % but this time i need it to look at a column range instead across a row.

I need it to alert me when column K34 to K90 values added together with a value in G 22 equals to or is over 100%.

This is my current code.

Please Login or Register  to view this content.

Help.

Preatorian...

**DonkeyOte** · 10-19-2009, 02:24 AM

If I've understood...

Please Login or Register  to view this content.

**Preatorian** · 10-19-2009, 09:59 PM

DonkeyOte, thanks again.

Question.

The code checks for 100% on these ranges, ("G22,K34:K90").

I have another set of ranges ("H22,P34:P90") that independently needs to have this alert as well. How can I modify this.

P-

**DonkeyOte** · 10-20-2009, 03:23 AM

Along the lines of the below perhaps ?

Please Login or Register  to view this content.

Code Modification to alert 100% and over

LinkBack

Thread Tools

Rate This Thread

Display

Code Modification to alert 100% and over

Re: Code Modification to alert 100% and over

Re: Code Modification to alert 100% and over

Re: Code Modification to alert 100% and over

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions