blakererucha
New Member
- Joined
- Feb 16, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi! I have data that I am trying to paste into the bottom of a table, but I cannot figure our how to do it. It keeps pasting into the same cell, not the bottom of the table. Here is my code.
Sub DAILY_DATA_LOG_INSERT()
'
' DAILY_DATA_LOG_INSERT Macro
' TO INSERT DATA INTO DAILY DATA LOG
'
' Keyboard Shortcut: Ctrl+Shift+I
'
Range("N3:AH3").Select
Selection.Copy
Sheets("DAILY DATA LOG").Select
Range("B62").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Thank you for the help!!
Sub DAILY_DATA_LOG_INSERT()
'
' DAILY_DATA_LOG_INSERT Macro
' TO INSERT DATA INTO DAILY DATA LOG
'
' Keyboard Shortcut: Ctrl+Shift+I
'
Range("N3:AH3").Select
Selection.Copy
Sheets("DAILY DATA LOG").Select
Range("B62").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Thank you for the help!!