VBA with Empty Cell in Error

Sorry, I am not sure I understand:

The above is my full code for 1 cell only. I havent figured out how to do c50-55 yet. Thanks!

If IsEmpty(Range("c50")) Then
Select Case MsgBox("c50 is empty. Do you want to continue?", vbYesNo Or _
vbQuestion Or vbDefaultButton1, "Select option")

Case vbYes
'This must be filled
Case vbNo
Exit Sub
End Select
End If

Capture.JPG

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Sorry! Did not know about this. I will post like below from now on. Thank you

Please Login or Register  to view this content.

Dear Mangesh,

Thanks for your reply. However, if I do not want the select case message box, just that if there is empty cell, message pop up and said "Cell C51 to C55 must not empty" I tried to take out that part but error message pop up saying i need select case. Thanks!

Please Login or Register  to view this content.

Thank you very much Mangesh! This site is so great!