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: 962

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

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:30 PM.