Increase range automatically within formula

[HKPHOOY]

Hi,

I have the following formula but have to keep extending the range each time I update the dataset, Is there any way I can adjust the formula to go to the last entry. In this case row 2321?

[xlnitwit]

If you use a Table for your data, the ranges will automatically expand when you use table references.

[HKPHOOY]

I'm importing it from SQL so nit sure it will retain table name when imported?

[xlnitwit]

If you are querying SQL server, it should come through as a table anyway.

[HKPHOOY]

Hi, It's a spreadsheet I've inherited. I just click the button and the data's imported into the sheet. I just tried creating the table but when I reimport it loses the table refrence

[xlnitwit]

What's the code to do the import?

[HKPHOOY]

Please Login or Register  to view this content.

[xlnitwit]

Is there already a table on the worksheet when you run that code?

[HKPHOOY]

Hi, yes there's already a table

[xlnitwit]

Try replacing this line in each routine

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

[HKPHOOY]

just getting a run time error with the code changes.

[xlnitwit]

What error?

[HKPHOOY]

Hi,

Run-time error '9':
Subscript out of range