How to AutoFill Series with code

[tuongtu3]

Hello all,
Is there a code how to autofill series up to 1000+ lines. Please look at the sample in attached.

Regards,
tt3

[tuongtu3]

Hello,
How to write a code to select range "BM4:BM14" autofill type fillseries dow to 1000 then code with "Concantenate each cell BM with "=" infront of its. Any hlep would be greatly appreciate.


AR4 CONCATENATE("=",BM5) become =AR4
AS4
AT4
AU4
AV4
AW4
AX4
AY4


AR5
AS5
AT5
AU5
AV5
AW5
AX5
AY5

Regards,
tt3

[tuongtu3]

Hi all,
Please take a look at my sheet in attached and run to see if you can help me out. Thank you very much for your time and help.

Regards,
tt3

[tuongtu3]

Hi all,
I tried with code in below and I have to manually double click at each cell to enable formula (it take forever). Is it possible to enable formula after click a button? Please take a look at an updated sample in attached.

Regards,
tt3

Please Login or Register  to view this content.