hi i am new to this forum, i am also new to VBA in excel. i have been able to do some scripting for my solution where i can select a number for employees and the number is transferred to another sheet and populated the respectibe number of rows = number of employess, i will be send the sheet to the number of employees who will be populating the sheet, i have created a button on the sheet which will run a macro to find empty cell in mandatory columns and is the value is empty need to send a message as "incomplete fields", i am not able to identify how i should go about it should i search by range or each column??
some advice on this would be greatful.