Hi,
I need a vba code where code will check one column...like column A and find out empty cell in Column A and pop out message.
Please note range in column A will vary from month to month.....hence we need code which analysis col A according to its range and then find out empty cell .
If possible, can tell which cell is empty...like msg says "Cell A584 and A 1067 are empty"
File attached for reference.
Many Thanks
I need a vba code where code will check one column...like column A and find out empty cell in Column A and pop out message.
Please note range in column A will vary from month to month.....hence we need code which analysis col A according to its range and then find out empty cell .
If possible, can tell which cell is empty...like msg says "Cell A584 and A 1067 are empty"
File attached for reference.
Many Thanks