Hey folks, I'm just starting to learn VBA and I've been struggling with one string of code on one of my side projects.
Untitled.png
I'm trying to copy a range and paste its values and formatting to the last empty cell after the last not-empty cell in column B
I've got white text on the top left corner of each range so the don't overlap. The second range under "trip sections" is what I'm trying to accomplish with VBA.
I commented it out so I know the issue is with "lastRowTS =Range ..."
Sub addTS()
Dim lastRowTS As Range
Sheets("TRACKER").Activate
lastRowTS = Range("B9:B" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Select
Range("AA1:AG6").Select
Selection.Copy
lastRowTS.PasteSpecial xlPasteAll
End Sub
Bookmarks