someboddy
08-29-2010, 01:57 PM
I want to set a range to the result of a formula - that means that every cell in that range will be set to the result of that formula applied to that cell. For example: if I have a formula "=RC*3" every cell in that range will be multiplied by 3.
Now, I know I can easily do it with a loop, but my range contains tens of thousands of cells, and I know Excel is optimized to do a similar action on a large number of cells. I can probably create a temporary sheet for this, but if there's a build in function that can do it my life would be much easier.
Now, I know I can easily do it with a loop, but my range contains tens of thousands of cells, and I know Excel is optimized to do a similar action on a large number of cells. I can probably create a temporary sheet for this, but if there's a build in function that can do it my life would be much easier.