Hi Team,
I am using below code to open input files from a cell.
I want to ensure it should not be blank. Shall I use and OR Operator here.
if blank exit the Macro.
Thanks
mg
I am using below code to open input files from a cell.
I want to ensure it should not be blank. Shall I use and OR Operator here.
if blank exit the Macro.
VBA Code:
'==============Validate File path=============
If wsFolderPath.Range("b1").value = "" Or wsFolderPath.Range("b2").value = "" Or _
wsFolderPath.Range("b4").value = "" Or wsFolderPath.Range("b6").value = "" Or _
wsFolderPath.Range("b8").value = "" Then
msgbox "FilePath should not be Blank in Ranges" & wbTemplate.Name, vbCritical
GoTo Myend
End If
Thanks
mg