BASIC Runtime error (Property/method not found: Selectitem)
Posted: Tue Aug 22, 2017 10:02 pm
Hi guys,
I've recently put a lot of sweat and tears into my beatiful Calc sheet, yet now that I'm trying to edit it a bit more I keep getting the same error when hitting 'apply' in the conditional formatting part. My sheet is build around conditional formatting, and I have an extra plug-in installed to be able to add more than the standard amount of formulas for one cell. Perhaps the sheet is too much? Because I have a lot (!) of condotional formatting for a lot of cells.
I am a total noob when it comes to Calc / Basic, So I did not touch the macros / code one bit as I have just been using the 'conditional formatting' window to edit. I've attached an image of the error below. It's really messing with my sheet and my progress, so I hope someone can help me out here!
edit: not sure if the image is displaying correctly. Here is the link if it doesn't: http://imgur.com/a/o4ywJ
I've recently put a lot of sweat and tears into my beatiful Calc sheet, yet now that I'm trying to edit it a bit more I keep getting the same error when hitting 'apply' in the conditional formatting part. My sheet is build around conditional formatting, and I have an extra plug-in installed to be able to add more than the standard amount of formulas for one cell. Perhaps the sheet is too much? Because I have a lot (!) of condotional formatting for a lot of cells.
I am a total noob when it comes to Calc / Basic, So I did not touch the macros / code one bit as I have just been using the 'conditional formatting' window to edit. I've attached an image of the error below. It's really messing with my sheet and my progress, so I hope someone can help me out here!
edit: not sure if the image is displaying correctly. Here is the link if it doesn't: http://imgur.com/a/o4ywJ