Thank everyone very much for suggestions
I would like refer to specific cells rather than range.
Could anyone tell me how to modify Range("A1:C1") into different cells? such
as A13, A67, A100.
Thank everyone for any suggestions
Eric
"Gary''s Student" wrote:
Very simple:
Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A1:C1")
If Intersect(r, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
r.Value = Target.Value
Application.EnableEvents = True
End Sub
Because it is worksheet code, it is very easy to install and use:
1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
To learn more about Event Macros (worksheet code), see:
http://www.mvps.org/dmcritchie/excel/event.htm
--
Gary''s Student - gsnu200756
"Eric" wrote:
Does anyone have any suggestions on how to do this trick in excel?
Within the cell A1, B1, C1, when I enter a number in one of three cell, such
as 3 in cell A1, then 3 will be automatically display on cell B1 and C1. On
the next step, if I enter 6 in cell B1, then 6 will be automatically display
on cell A1 and C1. On the next step, if I enter 8 in cell C1, then 8 will be
automatically display on cell A1 and B1.
Does anyone have any suggestions on how to do this trick in excel?
Thanks in advance for any suggestions
Eric