Macro to test Null values [Closed]

Question

Macro to test Null values [Closed]

Report

mrw - Aug 19, 2009 at 11:46 AM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- Aug 19, 2009 at 09:31 PM

Hello,

I have a spreadsheet where if I enter a numeric value between 3000 and 7000 (excluding values between 6000 and 6500) it checks to determine whether values in the same row are null. If they are, a message box appears indicating that null values are present). For exaple.

For Example: For any row if value in the column 'C' is NUMERIC and its value not between '6000' and '6500' then values in columns 'G' and 'R' can not be NULL

If anyone can assist that would be great !

Thanks,

Jenifer

Macro to test Null values
Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
Macro to copy and paste values ✓ - Forum - Excel
How to compare two cell values in excel using macro ✓ - Forum - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2009-08-19T21:31:11-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

796
Aug 19, 2009 at 09:31 PM

try this macro
Assumptions.
row 1 is having column headings. data is from row 2. there is no gap in column A

Sub test()
Dim j As Integer, k As Integer
 j = Cells(1, 1).End(xlDown).Row
For k = 2 To j
If IsNumeric(Cells(k, "c")) And Cells(k, "c") < 6000 Or Cells(k, "c") > 8600 _
     And Cells(k, "G") = 0 Or Cells(k, "R") = 0 Then _
    MsgBox "null values are present"
Next k
End Sub

Macro to test Null values [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!