Stop Macro if condition not met

[RAFARRAR]

Hello,

I have a macro that works fine. It is executed from a control button. I would like the macro to stop / end if the data in cell b17 is null.

How to I place this code into my existing macro?

Thanks!

Al

 

[Joe4]

Welcome to the Board!

Place this line at the beginning of your code:

If Len(Range("B17"))=0 Then Exit Sub

 

[RAFARRAR]

Welcome to the Board!

Place this line at the beginning of your code:

If Len(Range("B17"))=0 Then Exit Sub

Thanks Joe. This is EXACTLY what I was lookign for!

Al