Checks values in a range 10 rows by 5 columns : Cell Value « Excel « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Excel » Cell Value 




Checks values in a range 10 rows by 5 columns
 

Sub CheckValues1()
    Dim rwIndex As Integer
    Dim colIndex As Integer
    For rwIndex = To 10
            For colIndex = To 5
                If Cells(rwIndex, colIndex).Value <> Then _
                    Cells(rwIndex, colIndex).Value = 0
            Next colIndex
    Next rwIndex
End Sub

 














Related examples in the same category
1.Define a string type variable and set to Cell(1,D)
2.StrConv("ALL LOWERCASE ", vbLowerCase)
3.Format("ALL LOWERCASE ", "<")
4.Checks values in a range 10 rows by 5 columns with nested for loop
5.Place the value (result) of a formula into a cell rather than the formula.
6.Validation with a Spreadsheet Cell
7.Assing value in Cells to array, do the bubble sort and assign them back
8.transposes the values of a group of cells in a worksheet
9.Determining a cell's data type
10.Calculate cell
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.