Autofill with different Columns
 

I need to autofill a column without knowing what column its in. The column
can change so I locate the column by searching for a keyword from the
previous column, then offset to the location I need to be. I know how to
autofill a column with
Range("BC6").AutoFill Destination:=Range("BC6:BC")
This wont work everytime because the column may move. I am thinking
something along the lines of:
Selection.AutoFill Destination:=Range(???)
I know how to activate the first cell of the autofill but I am unsure how to
specify where to autofill.

Thanks