Help required to create autofill macro in row

Closed
sureshe Posts 2 Registration date Monday July 30, 2012 Status Member Last seen July 30, 2012 - Jul 30, 2012 at 09:43 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 30, 2012 at 11:53 PM
Hello,

Sub:Auto fill of Same value in different cells in a row using Macro button
Hi frnds,
Can anybody tel me how to auto fill of same value in different cells in a row?
For Example:
A1 D1 E1 G1 K1
10 10 10 10 10

like that when i hit a macro button the values in the A1 D1 E1 G1 K1 must fill with A2 D2 E2 G2 K2

Please help me.


Thanks

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 30, 2012 at 11:53 PM
some examples


range("a1,d1,e1,g1")=10
range("a5,d5,e5,g5")=range("a1,d1,e1,g1")
0