Hi!
Where are these "active cells"?
In a row? A1:IV1
In a column? A1:A65536
Just FYI, in Excel, active cell is a standard term that
means the cell that is currently selected. When you move
the cursor and select cell A1, cell A1 becomes the active
cell.
Biff
-----Original Message-----
Active is defined as a numeric entry... Let me also
better define:
40 cells - 35 active (numbers in them) - I want to count
the last 28, and
then get the lowest number (Min)
"Bob Phillips" wrote:
What defines active?:
--
HTH
RP
(remove nothere from the email address if mailing
direct)
"Sac73" wrote in
message
news:207089F2-80B4-46C8-863D-
...
Is there a way to count back a certain number of
active cells only (eg. 40
possible cells, only 28 are active), and then enter
the lowest number
within
that range into a cell?
.