|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro
Hi folks
I'm looking for some help with a budget spreadsheet which (hopefully!) is attached to this message. I have a handful of Functions set up in the VBA to calculate cells with specific Style names. For example: Quote:
Quote:
I'd be grateful if someone could have a look at the stripped down spreadsheet I've attached to illustrate the issue and see if they can shed any light on what's happening. I've added a few notes at the top and bottom of the document. Thanks! Matt |
#2
|
||||
|
||||
A quick fix might be to include
Application.Volatile as the first line of the function. |
#3
|
||||
|
||||
Hi. Thanks for this. It half works.
I've added the line as you suggested: Quote:
Quote:
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional function to operate a formula based on "Yes" or "No" Condition | Des ONeill | Excel | 1 | 07-03-2021 12:17 AM |
Condtional function to operate a formula based on "Yes" or "No" | Des ONeill | Excel | 3 | 07-03-2021 12:16 AM |
How do I delete the names under "Exceptions" when I use the "Restrict Editing" feature in Word? | MengS | Word | 0 | 02-25-2015 02:57 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |