Dividing the a rnge with a number
Posted by adi on February 14, 2002 8:50 AM
I was wondering if ther is a wy to divide the whole work sheet by a number....through a mcro...without actually going through each and every cell and doing it
Posted by lenze on February 14, 2002 9:21 AM
One way is to enter the number you want to divide by in a remote cell and copy it. Then select your range and use Paste Special, selecting the divide option