Hi,

Are you wanting to assign the minimum value to the variable "d?"

d = WorksheetFunction.Min(Columns("B"))

HTH
--
Ken Hudson


"kirke" wrote:

I want to save the minimum value of column B at "d"
So i define.
==============

Dim d As Long

d="=MIN($B:$B)"
================


However, it doesn't work. How can I save the number?
I can print it on a cell (for example, Cells(1,1)="=MIN($B:$B)" )

Thx'''