*probably simple* 'object required' error

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 ..."

Please Login or Register  to view this content.

Hi and welcome to the forum,

As per forum rules, please use code tags around your code.

You can simplify your code like this :

Please Login or Register  to view this content.

Don't use .SELECT and .ACTIVATE as it slows down your code

Thanks for the quick response!

I knew Ide end up breaking a rule immediately, once I chose not to read the rules. :p

I guess I better go read them now!

That code worked, thanks!

since I won't soon be able to write a code as intuitivly as GC's solution, could anyone tell me why my own code didnt work?

Hello,

the problem is this line :

Please Login or Register  to view this content.

When you want to "pass" a cell to a range variable you need to "SET" it, like this :

Please Login or Register  to view this content.