Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
seeking help on how to compare cell in two columns and get a message
if one is empty. i have column T and U and would like to get a message if cell t1 has something and cell u1 has nothing. if cell in column t have nothing just exit the sub. if T has something and u has something just exit the sub. just message when t has something and u does not. i tries looking up something and nothing fits that need. tried to cook up my own, but does not work. here is what i got Sub compare() Dim T As Range 'column T Dim U As Range 'column U Dim c As Range Set T = Range("T") Set U = Range("U") For Each c In T If T.Cells.Value = "" Then 'If T is empty the leave Exit Sub Else If T.Cells = 1 And U.Cells = 1 Then '1 as in something 0 as in nothing Exit Sub Else If T.Cells = 1 And U.Cells = 0 Then '1 as in something 0 as in nothing MsgBox ("my message here") End If End If End If Next c End Sub any help ? thnx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Compare two cells from reference cells | Excel Worksheet Functions | |||
Compare 2 cells in 2 worksheets, rewrite one of the cells | Excel Programming |