Set a constant from a formula in VBA
Dim K as double ' you sure you want Long???
with sheets("a")
k = application.max(.range("a:a"))
end with
Ed wrote:
I have now this:
Dim K As Long
With Sheets("A")
K = ( * here I want to have as k the result of the fomula =MAX(A:A).)
How do I manage to take values from formulas rather than a specific cell?
,thanks
--
Dave Peterson
|