Hi
I have just started learning VBA and I have an error coming up "subs cript out of range error)
I just have 2 workesheets in a workbook, one with a table of numbers, and I'm trying to get the minimum value within teh range and insert it in cell d5 of the previous worksheet. here's my code.
Sub MinValue()
Worksheets("Answers").Range("d8").Value = "=min(MyRange5)"
End Sub
I have just started learning VBA and I have an error coming up "subs cript out of range error)
I just have 2 workesheets in a workbook, one with a table of numbers, and I'm trying to get the minimum value within teh range and insert it in cell d5 of the previous worksheet. here's my code.
Sub MinValue()
Worksheets("Answers").Range("d8").Value = "=min(MyRange5)"
End Sub