Hi friends,
I’m getting error 1004 if there is no value in column ‘N’. The piece of code is as follows:

With Range("m7")
        .Value = "1"
        .AutoFill .Resize(Range("N" & Rows.Count).End(xlUp).Row - .Row + 1), 2
    End With
If column ‘N’ is blank then there should not be 1 in column ‘M’ and the macro should exit sub and continue because I have called another macro at the end of this macro. The series of macros should not be stopped, it should continue till the last called macro without any problem.

Any help will be appreciated.

Thanking you,