Sub Shuffle()
'
' Shuffle Macro
'
' Keyboard Shortcut: Ctrl+Shift+S
'
Range("e2:e53").Select
Selection.Copy
Range("j2:j53").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
this is the macro i have created to copy the range e2:e53 and paste those values in j2:j53. when i attempt to run i get an error
"compile error: expected end sub"
what does this mean. i am very new to VBA and this is the first one that i have attempted so i apologize for how rookie of a mistake this is. thank you for any help given!
Bookmarks