Anyway to set rule for XStatus error?

[blckngldhwk]

Is there a way to tell the macro to Exit Sub if at any point there is an XStatus error of value 3 (typing in protected cell)?

I can use an 'If statement' several times through the macro but I'd like to just use one statement at the beginning if possible. Thanks!

 

[SkipVought]

Hi,

Check out Error Handling in Extra VB Help.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]