**Hi,** I am trying to get the max number from a range. I have tied **2 approaches to do this**, one is working other is not but it should work. Below code is working for me, I can get max with this code.

```
Dim mymax As Range
    Set mymax = Range("b13").CurrentRegion
    Range("b11").Value = Excel.Application.WorksheetFunction.Max(mymax)

```

Now the code below this is not working, why it is not working? Technically it should work. Can you please let me why its not giving me max number?

```
Dim mymax As String
       mymax = Range("b13").CurrentRegion.Address
       Range("b11").Value = Excel.Application.WorksheetFunction.Max(mymax)

```

Thanks for your time and opinion.