In this vide, we are discussing, Kutools for Excel | How to divide range of cells by a number in Excel?
1. Select the range you want it to be divided by a number.
2. Click Developer then Visual Basic, a new Microsoft Visual Basic for applications window will display, click Insert and then Module, and then input the following code in the Module:
Sub DivisionNum()
'Updateby20140128
Dim Rng As Range
Dim WorkRng As Range
Dim xNum As Integer
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
xNum = Application.InputBox("Division num", xTitleId, Type:=1)
For Each Rng In WorkRng
Rng.Value = Rng.Value / xNum
Next
End Sub
Then click doc-divide-5 button to run the code. In a popping up dialog box, please select the range with numbers you want to divide by a certain number, and then click the OK button.
In the second popping up dialog box, enter the divisor number, and then click the OK button.
Perhaps the VBA code is somewhat difficult for you. Download kutools for excel to get more productive.
📌 Download Links:
➤ Download Dose for excel premium tools : https://bit.ly/dose-for-excel
➤ Get Dose for excel by using coupon code 25% OFF: Quizziin25
➤Get Kutools for Excel : https://bit.ly/ku-tools-for-excel
2. Kutools for Outlook : Brings multiple powerful features to Microsoft Office Outlook 2010 -2021 and Office 365.
Buy Now (Affiliated by ExtendOffice.com ): https://bit.ly/ku-tools-for-outlook
3. Kutools for Word : It is a powerful software that frees you from time-consuming operations which majority of Word users have to perform daily! It contains 100+ powerful functions and tools for saving hours of your time in Word.
Buy Now (Affiliated by ExtendOffice.com ) : https://bit.ly/ku-tools-for-word
4. Office Tab : It brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel and PowerPoint). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.
Buy Now (Affiliated by ExtendOffice.com ) : https://bit.ly/office_tab
5. Office Tab Enterprise : Office Tab brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel, PowerPoint, Publisher, Access, Project and Visio). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.
Buy Now : https://bit.ly/Office_Tab_Enterprise (Affiliated by ExtendOffice.com )
➤ Our Social Media Link :
➤ Facebook Page : https://www.facebook.com/quizziin
➤ Instagram : https://www.instagram.com/quizziin/
➤ Reddit : https://www.reddit.com/r/quizziin/
#kutoolsforexcel
#exceltutorial
#exceltricks
#exceltips
#msexcel
#excel
#kutools
#vba
