Hi all,
I have a simple macro that just copies a row like this below. This one is executed by Ctrl+A on the keyboard.
Cell A is suppose to work like an auto increment number. So for every new row that´s created the number from previous post is increment´s by 1.
Then i copy a row now looks like this.
This is what i want.
Is this possible to add to this macro ?
// Regards
I have a simple macro that just copies a row like this below. This one is executed by Ctrl+A on the keyboard.
Code:
Sub Macro1()
'
' Macro1 Macro
'
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub
Cell A is suppose to work like an auto increment number. So for every new row that´s created the number from previous post is increment´s by 1.
Then i copy a row now looks like this.
Code:
1
1
1
1
Code:
1
2
3
4
Is this possible to add to this macro ?
// Regards