Code no longer Working, Error 91

Hi,

I have a spreadsheet that uses this code on one of the sheets. It's used for charting a row of variables based on what row you click on. It can also chart based on what row you select with the up and down arrows (spinbuttons). Basically I have a row of variables and I load that row into the chart. The row is selected via CR7. The variables in the row are loaded using the "=INDIRECT("X"&$CR7)". I don't know what changed but this used to work, now when I open the spread sheet I get Error 91. As far as I can tell it might be that chkRowClick_Click() is not being set to True but I can't tell where it gets set on the sheet. I didn't make this sheet or code so I'm hoping this is a simple fix if anyone can help?

Thanks

Please Login or Register  to view this content.

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

Originally Posted by yujin

The attached file shows no error.

I've looked into the code but found nothing that might cause Error 91.

Well I'm confused then because the sheet doesn't work anymore. I can change rows and the chart doesn't get the corresponding row's values. Are you saying this part works for you?

I just don't understand why the:

=INDIRECT("J"&$CR7)
=INDIRECT("AW"&$CR7)

Line doesn't work? It used to work but now it doesn't update the value from row CR7. That is the Row that the chart uses for its input data.

Glad it worked.

Now I wonder why it used to work if that code was never there?

The Automatic Calculation is set to be "ON" by default but it can be accidentally turned off. By selecting Formulas ribbon and choose Calculation Options, you can change the setting.

What does Me.Calculate do?

"Me" is equivalent to "This Worksheet", so "Me.Calculate" recalculates the formulas of the sheet even if Auto Calculation is set to be "OFF".