Search results for query: *

Hi Guys (macropod & combo) Thanks a lot for your help. I will end up using ideas from both of your suggestions. I would never have worked this out as quickly myself. Great work. Thanks Mumfy.

Hi macropod, Thanks for your prompt responses. The second one worked very well. If I could ask now how to fully use this formula I would greatly appreciate you answer and your time. The formula looks like this: y = 4E-13x^6 - 1E-07x^5 + 0.0094x^4 - 491.82x^3 + 1E+07x^2 - 2E+11x + 1E+15 You...

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...

Skip, Thanks, your suggestion works perfectly and I don't need LockAspectRatio, Height or Rotation. A very elegant solution that deserves a star! Thanks again Mumfy.

Skip, Thanks for your quick response. The lines (up to 22) on the drawing layer form a shape that reflects some underlying data on the worksheet. However, the shape is too wide and I am trying to narrow it but NOT the individual lines. I am only setting the height to the initial value so this...

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...

Hi JohnAcc Thanks for the suggestion. I will look into it as it may be another way of addressing the issue. Regards Mumfy.

Hi xlbo No, there is no "calculating %" message in the status bar at the bottom. Thanks for the suggestion of displaying messages in the status bar. I was looking for something more visible but as you say it will let users at least know something is going on. Regards Mumfy

Hi Chattin Thanks for your response and suggestions. I have visited the links you posted, however, I don't believe they fit my need. Both solutions require you to know how far through the process you are AND have access to progress bar code from within a loop, unless I misunderstand. When I...

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...