Hi
I am trying to add two arrays with numbers in VBA and finally I will paste/export that summed up array to an excel sheet.
It is possible, I am not experience in VBA? Basically I want to do the same as taking a range and pastespecial add values onto another range but only keep the range in VBA to save time.
Here is my code if it helps. Get error Runtime 424 Object required. Any help appreciated.
Dim i As Integer, j As Integer, vbAntal_kontrakt As Integer, vbTenant_CF As Range, vbPortfolio_CF As Variant, vbTenant_record As Range Sheets("CASH_FLOW").Range("CFport_clear").ClearContents
j = 0
vbAntal_kontrakt = Sheets("Input_tenant_specific").Range("Antal_kontrakt").Value
For i = 1 To vbAntal_kontrakt
j = i + 7
Sheets("Input_tenant_specific").Range(Cells(j, "A").Address, Cells(j, "BV").Address).Copy
Sheets("Input_tenant_specific").Range("A4:bv4").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False 'Copy each tenant's data to the top row, which then generates monthly cash flows
Set vbTenant_CF = Sheets("Lease_analysis").Range("Tenant_CF")
Set vbPortfolio_CF = vbPortfolio_CF.Value + vbTenant_CF.Value 'THIS IS NOT WORKING
Next i
vbPortfolio_CF.Copy Destination:=Sheets("CASH_FLOW").Range("Portfolio_CF") = vbPortfolio_CF.Value 'DO NOT KNOW IF THIS IS WORKING