Hi,
I am using 2010 excel and have a data connection that refreshes every 3 minutes. I need to help to create a VBA macro that automatically scrolls my data from row 5 to row 50 and loop back again. The problem is that the macro i am using stops the data connection or freezes.
My data connection is fed from a website every 3 minutes updating my Dashboard report for the company to see. I have 50 rows displaying but need it to scroll up and down continuously and also refresh the data every 3 minutes.
I am not an expert and found the VBA code for scrolling which is:
Sub SlowScroll()
For i = 5 To 30
r = 1
Do Until r = 300
Cells(r, 30) = r
r = r + 1
Loop
ActiveWindow.SmallScroll Down:=1
Next i
Range("A5").Select
SlowScroll
End Sub
How can i get my report to scroll up and down and still refresh the data every 3 minutes.
Thanks
I am using 2010 excel and have a data connection that refreshes every 3 minutes. I need to help to create a VBA macro that automatically scrolls my data from row 5 to row 50 and loop back again. The problem is that the macro i am using stops the data connection or freezes.
My data connection is fed from a website every 3 minutes updating my Dashboard report for the company to see. I have 50 rows displaying but need it to scroll up and down continuously and also refresh the data every 3 minutes.
I am not an expert and found the VBA code for scrolling which is:
Sub SlowScroll()
For i = 5 To 30
r = 1
Do Until r = 300
Cells(r, 30) = r
r = r + 1
Loop
ActiveWindow.SmallScroll Down:=1
Next i
Range("A5").Select
SlowScroll
End Sub
How can i get my report to scroll up and down and still refresh the data every 3 minutes.
Thanks