Solved

compare excel values, not the formula

Posted on 2011-03-21
2
317 Views
Last Modified: 2012-08-13
Hi,

Ive got an excel macro that compares 2 sources (sheet 1 as source 1, sheet 2 as source 2). The problem Im having is that Im pulling the data from both sources using the same formula in both sheets and when my macro tries to compare it says there are no differences even though the values in the cells are different (the formula to derive the value in the cell is the same)

Ive attached the macro as a file

Cheers
macro.txt
0
Comment
Question by:DiCanio13
2 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
ID: 35186496
Rather than

cf1 = ws1.Cells(r, c).FormulaLocal
cf2 = ws2.Cells(r, c).FormulaLocal

try this

Dave

cf1 = ws1.Cells(r, c).Value
cf2 = ws2.Cells(r, c).Value

Open in new window

0
 

Author Closing Comment

by:DiCanio13
ID: 35186598
Cheers thats great
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

706 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

23 Experts available now in Live!

Get 1:1 Help Now