Hi



I have a worksheet which is used solely for entering data, that data is then
moved to a list via a macro attached to a button. The data entry cell ranges
are as follows, (there are no formulas in any of these cells and the cells
are merged) "D2:I2,J2:O2,C3:F3,L3:M3,S3:T3,.etc..".



What I would like to do is:- when the button is clicked; if all the cells
have data entered then have my existing "Macro1" run, if however any of
these cells have no entries then have a message box pop-up saying, say,
"Incomplete Data Entry". So to me it would look something like this:-



Sub SaveRecord()



If



all cells in the ranges "D2:I2,J2:O2,C3:F3,L3:M3,S3:T3,.etc.." have data
entered - (This is the bit I don't know how to code)



Then



Macro1



Else



'Message'



End Sub



Your assistance is valued.



Sandy