Autofill with different Columns

R

rockytopfan4ever

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Dynamic Range of Cells 2
Auto Autofill 2
AutoFill Macro Issue 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Autofill & On Error Resume Next 2
Please help to copy in a range 3
VBA to autofill from relative location 2
Autofill Error 4

Top