|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2007, 07:36 PM
posted to microsoft.public.excel.links
|
|||
|
|||
flagging cells that have been referenced
Is there anyway to flag a cell in worksheet 'questions' that has been referenced in worksheet 'test'. Example: In worksheet 'test', cell D3, I enter =questions!C15. I want to know that cell C15 has been used in worksheet 'test'. -- reedspencer 
|
|
#2
October 5th, 2007, 08:23 AM
posted to microsoft.public.excel.links
|
|||
|
|||
|
flagging cells that have been referenced
You could run this macro:
Sub ShowUsed() Dim C As Range For Each C In ActiveSheet.UsedRange.Cells C.ShowDependents Next End Sub To remove the arrows: Tools Formula Auditing Remove All Arrows Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#3
October 11th, 2007, 08:26 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
flagging cells that have been referenced
reedspencer;565435 Wrote: Is there anyway to flag a cell in worksheet 'questions' that has been referenced in worksheet 'test'. Example: In worksheet 'test', cell D3, I enter =questions!C15. I want to know that cell C15 has been used in worksheet 'test'. I will try it and see how things go. Thank you. -- reedspencer
|
|
#4
October 18th, 2007, 03:52 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
flagging cells that have been referenced
The macro worked great. Thanks for the assistance. Reed Spencer -- reedspencer
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
