Can I use a For Each to loop thru a named range, and say change the values? I know I can do it with a for next like the following:
Dim i As Integer
For i = 1 To Range("MyRange").Cells.Count
Range("Myrange").Cells(i).Value = Range("Myrange").Cells(i).Value * 3
Next i
Thanks.
Mike
Dim i As Integer
For i = 1 To Range("MyRange").Cells.Count
Range("Myrange").Cells(i).Value = Range("Myrange").Cells(i).Value * 3
Next i
Thanks.
Mike