hi Arlu,

in the above code, how to pass variables for Column #?

i got the value of the colno using
Application.WorksheetFunction.Match("Branch")

And i passed this colno to the below code as
If .Range(colno & i - 1).Value = "" Then
but wen i run its throwing "Application defined error"
Can you please tell any other work around is der