Quote:
|
1. How do I make the formula accommodate the expanding range
|
If you use real Excel tables that is automatic.
I guess the issue here would be how you are inserting your new data.
Here's a couple of links to sites with info on tables that is essential for vba.
Excel: Working with Tables (VBA)
The VBA Guide To ListObject Excel Tables — The Spreadsheet Guru
Quote:
|
2. Why does the formula extend to row 2626?
|
Eliminate the 26 you have inside the quotes. As you have it now
ws.Range("B" & ws.Rows.Count).End(xlUp).Row gives a result of 26
which is added to the end of what is between the quotes giving you F2:F2626