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

ijhoeq

New Member
Joined
Jun 20, 2018
Messages
46
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

MrExcel MVP
Joined
May 26, 2009
Messages
16,669
Code:
Range("C2:C" & Cells(Rows.Count, "B").End(xlUp).Row).Formula = "= RemoveChar(B2)"
 

Forum statistics

Threads
1,082,587
Messages
5,366,484
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top