Exit a Sub

[chammy88]

Hey,

I have written a procedure in VB that goes through a column and sorts it. The content and size of this column changes daily when the report is run. The problem arises when there is nothing in this column. When there is nothing in the column I get 'Error code 9'. Is there anyway of adding a bit in my code that does some thing like:
Range("A2").select
if A2 = "" Then
exit sub
resume next
end if

I have tried this but it doesn't work.

Any suggestions?

Thanks in advance.

 

[Jerry Sullivan]

Hi Chammy88,

You don't need to Select A2 or have a Resume statement.
You can just do this...

If Range("A2") = "" Then Exit Sub
'...Your sort code

 

[chammy88]

Well that was simple and I feel a bit silly.

Thanks for your help

 

[Jerry Sullivan]

You're welcome.
No need to feel silly - the Board is here to help with questions like that.