Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Tag/Identify Cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
joe.engel@hotmail.com - 29 Sep 2007 15:09 GMT
Is there a way to tag/identify cells with the same value? When
creating cell values off of cells with the same value, I need a way to
distinguish that they are/are not values created from the same cell.
Ex. :
(A1=10, A2=20, A3=30, A4=20)

Cells(1,2)=Cells(2,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Cells(1,2)=Cells(4,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Both of these produce the same results for cell "B2", although they
came from different cells in column A. I do not need to know where
they came from. Just that the values are from different cells.

Any help is appreciated.

Joe
Bill Renaud - 29 Sep 2007 21:34 GMT
Show Auditing Toolbar, then click on the "Show Precedents" button.

Or, double-click the cell. Excel will select all cells that are referenced
in the formula, unless this default behavior has been overridden by an
event macro.

Or, write a macro to cycle through all cells with formulas and look for
formulas that all have the same cell references in them ("B2"). (Not easy.)

Signature

Regards,
Bill Renaud

joe.engel@hotmail.com - 30 Sep 2007 13:46 GMT
On Sep 29, 4:34 pm, "Bill Renaud" <Bill.No.Spam.Ren...@Comcast.Net>
wrote:
> Show Auditing Toolbar, then click on the "Show Precedents" button.
>
[quoted text clipped - 8 lines]
> Regards,
> Bill Renaud

Thanks Bill. I'm going to write the macro that checks precedents for
the cells in question.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.