That code will be efficient, assuming that brainfart is a variable number,
it will select a range the same size as the currentregion offset by 2
columns and 1 row, if that is what you want.

You need to specify which currentregion, so you will need to qualify it with
a range, such as activecell, or Range("A1")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ward376" wrote in message
oups.com...
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.