ByVal Target Range Great Code but need Help
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
|