Hi Guys,

I'd appreciate some help with the following please.

I am creating a macro to copy specific columns from one worksheet and paste it into another. I am declaring variables for the ranges, but I dont know how to paste them into my new spreadsheet.

This is my code:

    

Dim FeeDetailRange As Range
Dim FeeCategoryRange As Range

Workbooks.Open sFile 'Open defined file

Set FeeDetailRange = Sheets("TABLE").Range("B7:" & ActiveSheet.Range("B7").End(xlDown).Address)
Set FeeCategoryRange = Sheets("TABLE").Range("C7:" & ActiveSheet.Range("B7").End(xlDown).Address)

ActiveWorkbook.Close False 'Close
ThisWorkbook.Activate 'Go back to original spreadsheet
Sheets("Baseline 2").Select 'Select relevant sheet

Dim TLR As String
TLR = Range("B65536").End(xlUp).Row + 1 'Find Last Row Number

Let Range("B" & TLR).Range = FeeDetailRange
Let Range("M" & TLR).Range = FeeDetailRange
The last 2 lines of the code don't work. How can I change it to past the two range objects?

Thank you
Chris