Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DelShannon
- Order by date
-
Choose consecutive, user-defined cell ranges
HI there, I have a spreadsheet with sequential dates in column A and corresponding prices in column B. I would like to copy consective sets of n days into column c and do analyses on them, in a loop. I am trying to write code that asks a user how many days to put into this "window" for analysis...- DelShannon
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
preventing screen updating with regression in excel
Thanks for the tip, Combo. I tried turning calculations off as you suggested but no effect. The output table gets re-written with each regression, and the screen along with it. Any other suggestions? Thanks, Del- DelShannon
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
preventing screen updating with regression in excel
I'm running a long series of regresions in excel 2002 (excel 10, I believe) and cannot turn off the screen updating of the output range. I have tried: Application.ScreenUpdating = False to no avail. The DoCmd.Echo command seems to be unsupported by VBA in Excel l0. The regression...- DelShannon
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
