Compare Two ex cel sheets and highlight differences

Hello There, Guest! Register

New To UFT? Join the best UFT Training Online!

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Compare Two ex cel sheets and highlight differences

Saket

Offline

Super Senior Member

Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0

#2

Not Solved

10-01-2009, 03:36 PM

You can use Round Function in your statements to round it up to 3 decimal places and compare

Code:
If Round(cell.Value,3) <> Round(objWorksheet2.Range(cell.Address).Value,3) Then

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

Compare Two ex cel sheets and highlight differences - by neerukonda9 - 10-01-2009, 03:24 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 10-01-2009, 03:36 PM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 10-01-2009, 03:57 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 10-01-2009, 04:11 PM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 10-01-2009, 04:17 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 10-01-2009, 04:59 PM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 10-01-2009, 06:07 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 10-02-2009, 10:15 AM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 11-03-2009, 04:57 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 11-03-2009, 06:20 PM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 11-03-2009, 07:00 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 11-04-2009, 09:47 AM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 11-06-2009, 04:20 PM

RE: Compare Two ex cel sheets and highlight differences - by rajrk - 06-02-2020, 01:32 PM

RE: Compare Two ex cel sheets and highlight differences - by rajrk - 06-03-2020, 12:04 PM

RE: Compare Two ex cel sheets and highlight differences - by Saket - 11-06-2009, 05:42 PM

RE: Compare Two ex cel sheets and highlight differences - by neerukonda9 - 11-06-2009, 10:08 PM

RE: Compare Two ex cel sheets and highlight differences - by vijaychourasiya0109@gmail.com - 03-02-2020, 03:58 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Compare WebTable Elements	saraiado	1	2,554	06-11-2015, 06:54 PM Last Post: venkatesh9032
	How to compare two binary values	Naresh	0	2,339	09-09-2014, 05:06 PM Last Post: Naresh
	Comparing two excel Sheets whose columns names vary	Divya Roopa	2	8,637	03-26-2014, 07:20 PM Last Post: Parke
	Iteration in Local sheets for UFT11.5	haithamQTP	1	3,192	02-27-2014, 09:12 AM Last Post: supputuri
	Record and run differences on "button with context menu"	cem404iuce	0	1,816	11-11-2013, 03:07 PM Last Post: cem404iuce

Users browsing this thread: 2 Guest(s)