Help required to create autofill macro in row

Closed
Report
Posts
2
Registration date
Monday July 30, 2012
Status
Member
Last seen
July 30, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
some examples


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