VBA to select & replace contents of cells

[kenadams378]

Hi,

I need to replace some data in certain cells but my current code won't work;

Please Login or Register  to view this content.

I'm trying to replace $G with $J just in cells H12 to K23??

Any ideas?

[Norie]

Change Cells to Range.

[bmxfreedom]

Replace .cells with .range like this:

Please Login or Register  to view this content.

[kenadams378]

Brilliant!

Many thanks