Hi
suppose your constant is in cell D1
In C1 enter Select column C
Go to the Home tab,clck Fill then Down

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, Pecoflyer

My columns and rows vary, but just substituting values worked a treat!

I'd like to mark this as solved, but I can't figure out how. Maybe someone else will.

Thanks again.

--fibbermcghee