Posted to microsoft.public.excel.programming

Dr. Schwartz[_3_] Dr. Schwartz[_3_] is offline

external usenet poster

Posts: 10

excluding a value in a max determination

Hi

I want to determine a max value in a range: =MAX(A1:A3

But if one of the cells has this format

With Selection.Interio
.ColorIndex =
.Pattern = xlLightU
.PatternColorIndex = 2
End Wit

I want to exclude it from the max value determination. Can anybody help me out with a piece of code that returns the correct max value

Thank yo
Schwartz

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
coefficient of determination	Jene	Excel Worksheet Functions	2	August 27th 09 02:39 AM
Pick value off sheet list for VBA code determination	Bill (Unique as my name)	Excel Discussion (Misc queries)	1	September 21st 07 06:52 PM
Date determination and sums	UnderCoverGuy	Excel Worksheet Functions	0	October 31st 06 08:16 PM
Earned Value Determination	Paul	Excel Discussion (Misc queries)	0	March 25th 05 09:27 AM
Average determination	Debra	Excel Worksheet Functions	4	November 1st 04 01:22 PM

All times are GMT +1. The time now is 03:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us