PLEASE HELP!! SELECT A ROW AND HAVE CELLS REFERENCE

fixemup27 · fixemup27's Computer Specifications

Is there a way to simply click (or highlight) a cell and have it reference "to" another cell?..I want the value in the cell highglighted (or clicked) to be reflected in some other cell within the same worksheet......Thanks!

goodfellow · goodfellow's Computer Specifications

I'm not sure if I follow you, but try this:

Quote:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(1, 1) = ActiveCell.Text
End Sub

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Up down arrow keys do not select cells if select locked cells unch	roandrob	Microsoft Excel Misc	6	18th May 2009 12:48 AM
how do you "select locked cells" w/o "select unlocked cells"?	=?Utf-8?B?cHJpbmNlam9obnBhdWxmaW4=?=	Microsoft Excel Misc	3	16th Jul 2005 03:53 AM
Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement	Kevin	Microsoft Excel Programming	7	5th Oct 2004 08:11 PM
Help! Anyone! Please Please Please Please Please Please	=?Utf-8?B?UmFuZHk=?=	Microsoft Access Macros	2	17th May 2004 07:16 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B	Hannes Heckner	Microsoft Excel Programming	1	5th Mar 2004 10:10 AM