Hello,
im running a macro to paste additional data to a table. So data grows by one row each time the macro is run. in trying to lock the sheet but have kept the range of the table 'unlocked' however the macro does not perform properly and when it is run the new data is pasted outside the table.
here is the macro being used.
any suggestions to fic this would be highly appreciate.
im running a macro to paste additional data to a table. So data grows by one row each time the macro is run. in trying to lock the sheet but have kept the range of the table 'unlocked' however the macro does not perform properly and when it is run the new data is pasted outside the table.
here is the macro being used.
any suggestions to fic this would be highly appreciate.
VBA Code:
Sub Create_Segment()
'
' Create_Segment Macro
'
' Keyboard Shortcut: Ctrl+Shift+S
'
Range("D29:K29").Select
Selection.Copy
Range("Table13[[#Headers],[Segment Code]]").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("E10:E13").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("E10").Select
End Sub