Fill down VBA Code

[joannakf]

I am trying to fill down a formula in a spreadsheet until the last row, the numbers of records returned will change with every download. I used control shift down on a column next to it and then tabbed over and filled up. It does not work correctly when the number of records change. An ideas?

Please Login or Register  to view this content.

Range("H6").Select
Is where it tabs over on row 6 instead of where ever the control shift down would end

Thanks in advance!

[WasWodge]

For the fill part you can try something like

Please Login or Register  to view this content.

Afraid I don't have time to look at the rest as it is getting on for 1am here

[WasWodge]

Hopefully this will cover your needs.Try it on a copy of your sheet. Let me know of any issues

Please Login or Register  to view this content.

[WasWodge]

Sorry correction of stupid error

Please Login or Register  to view this content.