Changing row count from 5 to 7 causing error message

[ALEXANAF]

Hi All,
I have the following coding (not written by me) that I need to change so coding so "For lngCnt2 = 1 To 5" is "For lngCnt2 = 1 To 7". The coding is used to populate a table that is used to build a chart.

When I run the coding after the change to test it, it works, the chart builds and I get no error message. BUT when I close the whole work sheet and try to use it again it throws the error "Application defined or object defined error" and I can no longer use the work book. I have been trying to figure out the problem, but I just can't see why it works until I open the whole work book. Any assistance would be greatly appreciated!

Coding for populating the table:

Please Login or Register  to view this content.

Coding for building the chart:

Please Login or Register  to view this content.

[xladept]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[ALEXANAF]

thanks for letting me know. Fixed now.

[kersplash]

Where is your code contained in the workbook (module?).

Where are the sub names?

[ALEXANAF]

Hi, the coding is in two separate modules. The coding I have extracted from much larger subs, one for generating data to fill all the tables in the workbook, the other to build all the charts in the work book. Do you need to see all the coding from both subs?

[kersplash]

If you can attach a workbook with the code and some sample data that would be good.

Go Advanced -> Manage Attachments -> Upload

[ALEXANAF]

I have uploaded it I think.

[ALEXANAF]

The subs in questions are called "GetRptNumericalData" and "CreateChart_ChtConformSumry"