macro shift the row of the selected cell up or down

[mark692]

Book1
	A	B	C	D	E
1	Date	Name	Price	Formula 1	Formula 2
2	25-Jan	Jam	2000	no	no
3	26-Jan	Richard	2500	no	no
4	27-Jan	James	3000	no	no
5
6
7
8
9
10
11
12
13
Sheet1

hi guys i have a table example is the above table, i want to make a button that will shifts rows from A to C up or down depending on the selected cell. is that possible? thanks

 

[James006]

Once you have tested the Event Macro ...

Feel free to share your comments ...

 

[mark692]

For your information ...an EVENT macro is a macro which does NOT need a button ... since it is triggered by an Event...

In this case, the event is whenever your double-click in any cell located in Column A ...

Hope this clarifies ...

ok i get it sir but what id my data is only on column B to C and F to H only?