What is the best way to go about dynamically selecting a range in a
column? I've been trying to do it in one line like
CurrentRegion.Offset(1,brainfart).FormulaR1C1 = "=RIGHT(RC[2],3)&RC[3]"

The number of record varies greatly in my project and I'm trying to
keep the amount of time it takes to run to a minimum.

Thanks to anyone that can help with this.