I'm trying to check if cell is empty or not in particular range (in column A)...Ok , i now how to check it ,but I don't know how to make the following:
If cell is not empty in defined range then I want to select that particular row (wher not empty cell is found) and change the row colour...Here is exacly what I want to make:
If not empty cell is found in range A10 then I want to select 10th row in range A10:AB10 and change color for selected cells...
Please help me to solve this..
Code for checking if cell is empty is belowe...
Dim r As Range
Set r = ThisWorkbook.ActiveSheet.Range("A10:A1500")
For Each cell In r
If IsEmpty(cell) Then