Like Anhn suggested, your code should be clearer to read. you can further clean it up and write it as...
vb Code:
Sub test() If (CurrentTitle = "DOM" Or CurrentTitle = "USA") And (HeaderNum = "2") _ And (prev = "EAST") And (vari = "FOLIO") Then 'use "Call", if it is a sub Call MakeChanges2_9 Application.StatusBar = "2_9Using EAST Zone FIRST Edition as source for FOLIO Zone" End If End Sub
Hope this helps...




Reply With Quote