VBA Help with Copying User Selected Cells and Paste Values down 1 Row

[CongoJr]

Can a macro be made for the following...

The user will select cells in a row (like I3,J3,K3,N3,O3) but i will not know which row they will be selecting from and copy those values down 1 row

Thanks for your help

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub CongoJr()
   Dim Rng As Range
   For Each Rng In Selection.Areas
      Rng.Resize(2).Filldown
   Next Rng
End Sub

 

[CongoJr]

Thanks Fluff!!!
I can make that work.
Sorry, but i have no idea what i am doing with the code, but is there a way to paste down just the values?
My border formatting is getting messed up a bit. If not, no big deal I am so glad it is working!
Thanks Again

 

[Fluff]

For values only try

Sub CongoJr()
   Dim Rng As Range
   For Each Rng In Selection.Areas
      Rng.Offset(1).Value = Rng.Value
   Next Rng
End Sub

 

[CongoJr]

Thanks Again Fluff...Works PERFECT

 

[Fluff]

You're welcome & thanks for the feedback