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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Capture values for polynomial trend line
Does anyone know how I can capture the VALUES when I generate a polynomial trend line on a chart using the ADD TREND LINE facility in MS Excel? I need to do this as I want to compare some of my data values to the trend line values so I can do further analysis on my data values. I would greatly...- Mumfy
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Programatically narrow grouped shape width
Hi Everyone I would appreciate any help to fix the following problem. I am running Excel 97 on NT V4.0. I want to change the width of a grouped shape consisting of up to 22 perpendicular lines using the following code. This code works in Excel 2000 running on Windows 98 SE but does not work...- Mumfy
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Progress Bar During Sheet Recalculation
Hi all I need to put a progress bar on a form to indicate the progress of a worksheet recalculation. I have a worksheet with 12 columns and up to 10,000 rows containing formulas that are recalculated twice per run. I use the .ENABLECALCULATION=TRUE to trigger the recalculation. During testing...- Mumfy
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
