Display error message if cell has no value

Hi all hope we're all well.

I've written a macro which is assigned to a button - when the user clicks, the file is saved as the value of what is in cell C32. This new file is saved in the same destination as the original...

flToSave = .Path & "\" & .Worksheets("Store & Scheme Details NEW").Range("C32").Value _
& "_" & ".xls"

There is a formula in C32 to concatenate 5 separate cells into one name. This works perfectly when all 5 cells are filled in, however if a use misses out a box we get a '#VALUE!' error in C32. This then prompts the user of the the problematic macro and gives them the option to end or debug the macro (which I don't want them to do!!)

Any way to simply call up an error message if all 5 cells aren't filled in? Was hoping to be able to define this message myself.

Hello - we're just concentrating on C32 alone. The five cells have basic bits of data in, just text and a date.

The formula in that cell is as follows:

=CONCATENATE("FIELD OPERATIONS"&" "&C19&" "&C20&" "&C18&" "&F32&" "&TEXT(G32,"dd.mm.yy"))

Thanks for your reply - that looks an excellent bit of code. I do however get the variable not defined message.

Do I need to dim 'r' as something