Replace Text in a cell

Hi Nicole

Thanks for getting in touch. This is much easier than you might think. You can modify the contents of any cell with the format

Range(cell reference) = new value

So your code would look something like this:

Sub change_title()

Range("A1") = "Constituent Unique Ref No"
Range("B1") = "ConsID"
Range("C1") = "My label"

End Sub

Just a footnote on that, if you want use a number leave off the quotes, else Excel will treat it as text:

Range("A1") = 150

If you're looking to do a "find and replace" style action, record that code and modify accordingly.

I hope that helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector