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" <(E-Mail Removed)> wrote in message
news:FDD5052D-BFE3-452E-B2DC-(E-Mail Removed):

> 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" <(E-Mail Removed)> wrote in message
> news:FDD5052D-BFE3-452E-B2DC-(E-Mail Removed):
>
> > 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
>
>