Solved

Ignore "inconsistent formula" vba

Posted on 2014-10-24
3
1,108 Views
Last Modified: 2014-10-24
Hi,

I am sending a wb some colleagues, though i have my inconsistent formula turned off on my PC, they wont on theres, can i run that into a module, so that those annoying warnings are turned off on opening the spreadsheet

Thanks
0
Comment
Question by:Seamus2626
  • 2
3 Comments
 

Author Comment

by:Seamus2626
ID: 40402232
But i need them to be turned back on exiting the spreadsheet
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 40402272
You can run a loop for specific ranges and errors:

Sub IgnoreInconsistentFormulas()
Dim cell as Range
for each cell in selection
 cell.errors.item(xlInconsistentFormula).ignore = true
 next cell
End Sub

Open in new window


for example.
0
 

Author Closing Comment

by:Seamus2626
ID: 40402319
Thanks!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now