Cell References and Ranges
Seems like it would be:
Replace What: Range("B2")
With: Cells(2, 2)
"Dan Kelly" wrote in message
:
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
|