Code to replace text in a range of cells in a particular column

Hi Guys,

Can someone helpe me with nice little piece of code that would replace all the contents of say Row C with the word "Standard"

The Rows range from 4 to 1742. Basically I need a code that will check if any cell in the above range is not null and if the cell is not empty then replace the contents of that cell with the word "Standard"

Thanks in advance.

Try

For rows 4 to 1742

Please Login or Register  to view this content.

or column C

Please Login or Register  to view this content.

VBA Noob

Hi VBA Noob, thank you so much for your rapid response.

Is there any way to combine these two codes as I only want the replace code to work throuch C4 to C1742. I appologise if I did make this clear in my earlier post.

Try

Please Login or Register  to view this content.

VBA Noob

Wow! A nice and small piece of clean code!

Thank you so much VBA Noob this works an absolute treat.

Thanks again.

Glad it helped and thx for the feedback

VBA Noob