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

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

Thanks,

I was sure that I had tried and that and it wasn't accepted.

it is now.

Cheers

"JMay" wrote:

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