LinkBack URL
About LinkBacks
I am looking for a way to cause my excel workbook to automatically scroll down to the bottom of the data set and begin from the top once completed
!Any help on this issue would be greatly appreciated
I am looking for a way to cause my excel workbook to automatically scroll down to the bottom of the data set and begin from the top once completed
!Any help on this issue would be greatly appreciated
What exactly do you mean by "automatically", and "once completed"? What's your workbook structure?
You could use something like
but need your definitions to determine which event(s) should trigger the code, and what the address parameter(s) should be...
Please Login or Register to view this content.
Attaching a workbook with a clear explanation of your required workflow would help most.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Olly,
I apologize for the ambiguity of my query. I am trying to implement a macro or function that will begin scrolling down upon the pressing of a button (or other similar movement) and once the scrolling reaches the bottom of the data set, it returns to the top of the data set to begin scrolling down again.
Attached I have the workbook that I wish to have scroll..
TEST Call List.xlsmTEST Call List.xlsm
Sorry, I still can't really understand what you're trying to achieve.
Well bummer. I'm trying to think of how else to explain it. Is there any way for an excel document to scroll automatically?
I made some changes to the code in your workbook:
I removed the array, because you're only scrolling down and not up, added in a DoEvents before each Next so your OS doesn't wig out for holding up the processor queue, and reselected A1 after each full scroll. It cycles 5 times, per your original code.
DoEvents is also nice for being able to interrupt the loop without screen freeze.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Although that would be cool to accomplish, it would shortly become very annoying. I would suggest not to spend to much time on this.
Daffodil11,
Thank you for your assistance! It works great! Is there anyway to make this loop back to the top once it hits a predetermined cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks