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