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?
Range("H6").Select
Please Login or Register to view this content.
Is where it tabs over on row 6 instead of where ever the control shift down would end
Thanks in advance!
For the fill part you can try something like
Afraid I don't have time to look at the rest as it is getting on for 1am herePlease Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
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.
Sorry correction of stupid error
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks