Function onEdit advice

[kwd53]

I have been using this to load my default setting when I change cell O7
it works nicely but I am always looking for ways to improve my options I am unsure if I could array any of the data changes to make it quicker or less troublesome

I had to do the coupon code after the base setting were put in since it has options that override the default settings
I suppose I could eliminate some of those changes to the VIP account for less overhead

any advice would be greatly appreciated

Please Login or Register  to view this content.

[Glenn Kennedy]

Moved to Googlesheets sub-forum

[veyselemre]

Hi, try this.

Please Login or Register  to view this content.

[kwd53]

Well that certainly was a lesson load all shared vars first then load just what else each requires. I did a clear all check boxes just before loading them all since my sheet has a ton of unique variables and it was certainly easier to clear them all.

thanks so much veyselemre

[veyselemre]

Glad to be of help