Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
I know how to use paste special to perform simple calcs on a range,
is there a way to perform more complex calculations on a range of cells?
say Range(A1:D10) is populated with values,
I would like to perform, I don't know, maybe the clean() or substitute() function on the values, and paste the new values over the original ones?
Thanks, as always,
Corticus
is there a way to perform more complex calculations on a range of cells?
say Range(A1:D10) is populated with values,
I would like to perform, I don't know, maybe the clean() or substitute() function on the values, and paste the new values over the original ones?
Thanks, as always,
Corticus