MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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