Cell References and Ranges
At the moment I use the following code to set the format for cells on my
worksheet
Range("B2").Select
Selection.RowHeight = 60
With Selection.Font
.Name = "Akzidenz-Grotesk Std Regular"
.Size = 24
End With
I would like to change the code so that instead of "B2" I use "Cells(2, 2)".
However a straight replace doesn;t work.
Any Suggestions?
I can see how to replace
|