copy and paste visible data in "M" Column to one cell above in excel VBA

[Giriraj Desai]

Hi ,

Could anyone please help me in i want a macro file which will copy one cell above in Column "M"

1. the data will be Column "M" always.
2 the data may be in any cell in column "M"
3. where ever the data is it should copy one cell above in same column "M".

example : the if the data is in M10 it should copy to M9 and in M15 to M14 and where the data is not there it should remain as blank.

Thanks and regards.
Giriraj.

 

[AlanSidman]

Sub desai()
ActiveCell.Copy ActiveCell.Offset(-1, 0)
End Sub