Hi

I need to copy a cell value down into all cells in a column where there is a value in column A. So if I enter 'Yes' in cell C2 and there are values in A2 to A300 then I want 'Yes' to be copied from C2 to C300. Could be that the next time I run the code there are 5000 values so I can't hardcode the range to copy down to.

Thanks for any suggestions.