Add New Column to the Right and Autofill

[sagarvpatel]

Hey Everyone,
I've been trying to create a macro to do this for the past day and I'm getting nowhere. Any help would be appreciated.

I have have formulas in column B that I want to drag horizontally. Basically, I'm trying to create a macro that will add a column to the right of B (want it to add a new all the way to the right every time the macro is executed) and then Autofill the column with data from the column on the left. Any ideas?

[HaHoBe]

Hi, sagarvpatel.

maybe have a look at this code and give it a try:

Please Login or Register  to view this content.

Ciao,
Holger

[sagarvpatel]

Thanks! That does what I want it to do if my ActiveCell is the last column to the right. If its not, it will insert a column next to whereever my ActiveCell is. Is there any way to force this macro to always run using the right-most column?

[HaHoBe]

Hi, sagarvpatel,

IŽd expected the data range to end if I press CTRL+RightArrow but maybe you have more than one list in there:

Please Login or Register  to view this content.

Ciao,
Holger