RolanDoobies
Board Regular
- Joined
- Aug 28, 2002
- Messages
- 99
Here is the macro I run now.
Sub Deal_Report_Formula()
'
Range("E5:H5").Select
Selection.FormulaArray = _
"=VLOOKUP(RC2,'F:\DEAL REPORT\[CURRENT DEAL REPORT.xls]Sheet1'!R2C1:R1792C7,{4,5,6,7},0)"
Range("A1").Select
End Sub
The problem I have is the report changes each week in size. sometimes its only 1000 rows, sometimes its 2500, or anywhere in between. How do I get it to work when the source size is not always the same?
Sub Deal_Report_Formula()
'
Range("E5:H5").Select
Selection.FormulaArray = _
"=VLOOKUP(RC2,'F:\DEAL REPORT\[CURRENT DEAL REPORT.xls]Sheet1'!R2C1:R1792C7,{4,5,6,7},0)"
Range("A1").Select
End Sub
The problem I have is the report changes each week in size. sometimes its only 1000 rows, sometimes its 2500, or anywhere in between. How do I get it to work when the source size is not always the same?