Auto fill Columns specified to and from (from a cell - i.e. dynamic)

[tompee29]

Hi,

Hoping you can help.
I need some simple code for being able to specify what column to copy and how far to copy it.
I.e. if i want it to copy column d and auto fill to column z (but specify this in say cells A1 and A2 - so A1 has D in it and A2 has Z in it) what would be the code for this?

Thanks,
Tom.

[JLGWhiz]

Your example for autofill is not clear. To autofill, the range must include the cell with the value to enter into the fill range. So to fill Column A with the letter "d", assuming "d" is in A1 and you want to fill down to row 20.

Please Login or Register  to view this content.

If you are not sure how many rows are needed but you want it to be the same as column B data, then

Please Login or Register  to view this content.

[tompee29]

Thanks for your reply...

Sorry i explained that really badly.

So in this following code i want to make Columns("E:E") and Columns("E:L") dynamic:

Please Login or Register  to view this content.

So it would look something like this

Please Login or Register  to view this content.

So then in cell A1 I would type E and A2 I would type E. Then run the macro.....

Obviously the code above doesn't work and there is probably a much simpler way to solve this.....

I am looking to do this as i have numerous sheets that need to be extended the same range periodically but then get copied and pasted to and from different columns each time i do it...

Apologies if still doesn't make sense....
thanks
Tom

[JLGWhiz]

I don't believe you want the entire column to autofill all the way down to the last row on the sheet. That's over a million rows. You can determine the last row in your data set by

Please Login or Register  to view this content.

Then you can use that like

Please Login or Register  to view this content.

That would give you a range filled to the last row of the data set that existed at the time you run the macro.