Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro

01-07-2022, 12:44 PM

p45cal

Windows 10 Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

A quick fix might be to include
Application.Volatile
as the first line of the function.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 PM.