Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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

Re: Dividing the a rnge with a number

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.