View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Nearest one or two or three numbers in a row of data

Auric__ wrote:

The first argument is the cell containing the value to check against.


Forgot to mention, if the first arg is a multi-cell range, you'll get an
error. (Type Mismatch in VBA; #VALUE! in a cell.)

--
The time is now, the now is here.