I'm trying to copy the current location, cell, then moving to a different sheet and pasting the value. It will have to drop down a cell before the past. I used the record with no good results. It might be a timing issue, which I don't understand.
Sub STGCheck()
'
' STGCheck Macro
' Copy location to WorkSheet Remove
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Range("B181148").Select
Selection.Copy
Sheets("Remove").Select
Range("A6").Select
ActiveSheet.Paste
Sheets("I-Drive(Files-Only)").Select
Application.CutCopyMode = False
End Sub
Bob
Sub STGCheck()
'
' STGCheck Macro
' Copy location to WorkSheet Remove
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Range("B181148").Select
Selection.Copy
Sheets("Remove").Select
Range("A6").Select
ActiveSheet.Paste
Sheets("I-Drive(Files-Only)").Select
Application.CutCopyMode = False
End Sub
Bob