ByVal Target Range Great Code but need Help
DANG! BERNIE!
If I could give you more than one Perfect rating I would Thank you, Thank
You, Thank You
Question. I have a duplicate of this on sheet 2:
Is there anyway to merger the 2 sheets. That is ,as if I would copy (sheet2)
From A1 to J100 and paste it into sheet 1 around L1? Can you run both on one
formula or must the entire thing be redone?
Thanks anyway fanfriggin tastic!
Mark
"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
|