How to apply a formula in a column next to data using VBA

[ijhoeq]

Hello,

I have data in columns A:B that changes in the number of rows. How can I apply a function I wrote (RemoveChar(B2)) to column C2:End? I can't seem to figure out how to apply the formula downward until the last data point at the end of column B.

Thanks!

 

[JoeMo]

Range("C2:C" & Cells(Rows.Count, "B").End(xlUp).Row).Formula = "= RemoveChar(B2)"