JARichard74
Board Regular
- Joined
- Dec 16, 2019
- Messages
- 114
- Office Version
- 365
- Platform
- Windows
I have this formula. I keep getting application-defined or object-defined error 1004
That I want to change as follows:
Bids!R1:BA1 refers to Bids!Cells(1, 18), Cells(1, lColumn)
Bids!I3:I8 refers to Bids!Cells(3, 8), Cells(lRow, 8)
Bids!R3:BA8 refers to Bids!Cells(3, 18), Cells(lRow, lColumn)
Where
lRow = Range("I1").End(xlDown).Row
lColumn = Range("A2").End(xlToRight).Column
Thanks
VBA Code:
.Range(.Cells(k * z + j + 3 - z, 2), .Cells(k * z + j + 3 - z, 2)).Formula = "=XLOOKUP(Price!$A" & (k * z + j + 3 - z) & ",Bids!R1:BA1,XLOOKUP(Price!$A$" & (k * z + 3 - z) & ",Bids!I3:I8,OFFSET(Bids!R3:BA8,0,6)),,2)"
That I want to change as follows:
Bids!R1:BA1 refers to Bids!Cells(1, 18), Cells(1, lColumn)
Bids!I3:I8 refers to Bids!Cells(3, 8), Cells(lRow, 8)
Bids!R3:BA8 refers to Bids!Cells(3, 18), Cells(lRow, lColumn)
Where
lRow = Range("I1").End(xlDown).Row
lColumn = Range("A2").End(xlToRight).Column
Thanks