Solved

Ignore "inconsistent formula" vba

Posted on 2014-10-24
3
979 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 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