Hi friends

I have a Column containing number. Everyday I add one value to this
column.
(say todays there are 20 rows than tomm. I will add one value and will
make 21 rows). I want to display the minimum value from these values.
How to do this using *VBA*?

Thanks in advance
:) JohnBest:)


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=497224

No need for VBA. Just create a named formula that automatically
adjusts to new data. Given your data in column A, I will assume row 1
is a header.

Then, use Insert | Name Define... and create a name such as BaseData.
In the 'refers to' enter

=OFFSET('Basic Range'!$A$2,0,0,COUNTA('Basic Range'!$A:$A)-1,1)
where 'Basic Range' is the name of your worksheet.

Now, you can use =MIN(BaseData) wherever you want and the formula will
adjust itself as you add data to column A.

For some other applications see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hi friends

I have a Column containing number. Everyday I add one value to this
column.
(say todays there are 20 rows than tomm. I will add one value and will
make 21 rows). I want to display the minimum value from these values.
How to do this using *VBA*?

Thanks in advance
:) JohnBest:)


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=497224

If you don't have anything else in that column, you could just use:

=min(a:a)
as a worksheet formula.

In code, you could use:

msgbox application.min(activeworkbook.worksheets("sheet1" ).range("a:a"))



johnbest wrote:

Hi friends

I have a Column containing number. Everyday I add one value to this
column.
(say todays there are 20 rows than tomm. I will add one value and will
make 21 rows). I want to display the minimum value from these values.
How to do this using *VBA*?

Thanks in advance
:) JohnBest:)

--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=497224

--

Dave Peterson