Application.Median(Range("C1:J100"))

--
Regards,
Tom Ogilvy

"K McCurry" wrote in message
...
How do I set up a macro to calulate Medain? The median will be in in its
own
column which is col K and the data will be cols c through J. Also the
data
could be off any size (could many records). Thanks.