Flexrod - Excel 2000 and 97 Problem

Larry Lohkamp and Lowell Davis have reported problems running the calc macros in Flexrod. They are using Excel 2000 and Excel 97. I built the macros in Excel 2003. Larry figured out how to fix it in Excel 97. Here's his note:

The failure occurred when pressing the calc button on tapers sheet, and
I assume the list calc would fail also. The other buttons work correctly.

An error dialog pops up when trying to run the 'calc'. The dialog says error 1004. When I went to the debug page, the sort command was highlighted. I buggered around with the command until i got it to work. The part that has to be removed is:

Remove:

DataOption1:= x1SortNormal

Lowell used a modified version of Larry's instructions to fix the macros in Excel 2000:

Remove:
, _
DataOption1:= x1SortNormal

These changes would need to be made in the Flex_Calc and Flex_Calc_All macros.

David