VBA basic question
Or this will work:
Sub MacroTaDa2()
Dim p$
p$ = "C3:C20"
For Each c In Worksheets("Stats").Range(p$)
Debug.Print c.Value
Next
End Sub
"kirkm" wrote:
I should know why this doesn't work...but
get 'Wrong number of arguments or invalid property assignment'
and can't resolve it.
With Worksheets("Stats").Range(p$)
For Each c In .Range
Debug.Print c.Value
Next
End With
The value of p$ is "C3:C20"
Many thanks - Kirk
|