Thread: minimum value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirke kirke is offline
external usenet poster
 
Posts: 11
Default minimum value

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'''