ByVal Target Range Great Code but need Help
If you mean that whatever is entered in a cell in B1:B100 get put onto row 3 only, then you could
replace
Target.Resize(1, 3).Cut Target.Offset(0, 1)
with
Target.Copy
Range("C3").Insert Shift:=xlToRight
Range("F3").Clear 'This is optional
Target.Clear
HTH,
Bernie
MS Excel MVP
"Mark" wrote in message
...
I enter a number in B3 sometimes down to B100
I need that # to go to C3, I need C3 to overide D3 and D3 ro overide e3,
basically continue to track the last 3 entries.
My formula only works for B3
Additional info F3 is =average(C3:E3)
"Bernie Deitrick" wrote:
Sorry it didn't work : The code I have works acrros B3
It did not work in any cell between B4:b100
It does work, on every cell in the range B1:B100, as long as
1) you enter a value into a single cell
2) you enter a number
If you want to lift the single cell restriction, then remove
Or _
Target.Cells.Count 1
HTH,
Bernie
MS Excel MVP
|