ADD your Macros which help to save your time every day while you are working with Excel.

[Rafa100]

ADD your Macros which help to save your time every day while you are working with Excel.

[Rafa100]

Copy from Below as opposed to shortcut Ctrl+D (which copies value from above). I have assigned CTRL +SHIFT+D for copy from Below

ActiveCell.Offset(1, 0).Range("A1").Select
Selection.Copy
ActiveCell.Offset(-1, 0).Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

[Rafa100]

You can Un colour cell with following VBA

With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub