Previous developer in my company developed a macro for us.

He has set to terminate the macro if the rows are more than 600

i dont know how he did that

Is there anyway by which i can increase that size to 800 or so??


Please advise.

you can mail replies to [email protected]

Thanks

Most likely there is some code somewhere in VBA that says:
    If ActiveSheet.UsedRange.Rows.Count > 600 Then
 and then the exit routine follows.