Hi all,
i have been working on a creating a macro to find specific name in column G and wanted to check if the the cell right to the current cell is empty. if empty warning should be displayed.
Detailed explanation:
In my sheet in column G i have enter 'A' 'B' and 'c' randomly till row 1200 like below and i wanted to check if the cells right to the 'A' and 'c" contains empty cell or not, if empty cell found message box should say "Empty cell present please fill in the details"
Column G column H
A xxx
A (empty cell)
B zzz
C yyy
B yyy
A xxx
B zzz
C (empty cell)
i have been trying to figure out solution for this and it would be great if someone can help me out. it will save me lot of time.
Thanks in advance
i have been working on a creating a macro to find specific name in column G and wanted to check if the the cell right to the current cell is empty. if empty warning should be displayed.
Detailed explanation:
In my sheet in column G i have enter 'A' 'B' and 'c' randomly till row 1200 like below and i wanted to check if the cells right to the 'A' and 'c" contains empty cell or not, if empty cell found message box should say "Empty cell present please fill in the details"
Column G column H
A xxx
A (empty cell)
B zzz
C yyy
B yyy
A xxx
B zzz
C (empty cell)
i have been trying to figure out solution for this and it would be great if someone can help me out. it will save me lot of time.
Thanks in advance