Compare Macro

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: atrscomputers@xxxxxxxxx (Andrew T Smith)
Date: 21 Apr 2005 05:46:19 -0700

Hey,

I'm looking to create a macro that compares one cell to a range of
cells in another work book. If the cell matches a cell in the range if
highlights the original cell. Is this possible and if so how.

Andrew
.

Follow-Ups:
- Re: Compare Macro
  - From: Tom Ogilvy

Prev by Date: Download files without alerts by Excel VBA
Next by Date: Re: IF AutoFilter is on, turn it off
Previous by thread: Download files without alerts by Excel VBA
Next by thread: Re: Compare Macro
Index(es):
- Date
- Thread

Relevant Pages

Re: Selectively replace cells based on two ranges of criteria - nested IF() statements?
... I want to replace specific positions in a cell ... e.g. 3 discrete coordinates that apply to separate data references. ... "top" line in this ambiguous statement to: ... my method compares 2 lines at a time. ...
(microsoft.public.excel.misc)
Selectively replace cells based on two ranges of criteria - nested IF() statements?
... I want to replace specific positions in a cell ... e.g. 3 discrete coordinates that apply to separate data references. ... "top" line in this ambiguous statement to: ... my method compares 2 lines at a time. ...
(microsoft.public.excel.misc)
Re: Need help creating a formula
... because it only compares a single value for example, ... Now imagine a list of jobs, ... Either I'm not understanding you, or you don't understand VLOOKUP, or you ... Also the Table and the location (cell address) of the Table. ...
(microsoft.public.excel.programming)
Re: How to write a for loop to get the range between a ,b columns
... This compares the cell in column A to the cell in column B on the same row. ... Sub rngCompare() ... For x = 1 To NumRows ...
(microsoft.public.excel.programming)
Need more =if functions
... I'm trying to do an if,then function that looks at data in a cell and ... compares to 13 different possible results but excel on allows 7 nested IF ... Prev by Date: ...
(microsoft.public.excel.misc)