Getting error 91

[mukeshbaviskar]

HellO Friends,
In my code I'm getting error 91 and the macro is not running. Please find the mistake in my code and send me corrected code. Please see the attachment.
Sort_access is a sorting macro
Sort_welcome is a macro to run the sort_access macro automatically at the time of opening.
Thankinng you in anticipation.


Mukesh

[Norie]

Why not attach an Excel workbook with the code and some sample data?

Also, can you indicate where/when the error occurs?

[mukeshbaviskar]

Hello Norie,
Thank you for response. Now I have attached my sample file 'Access'. The error occurs after opening the file. In search sheet I don't want to paste the data of sr. no. from b6:b2000 only I want to delete the data from b4:c4. I don't understand why this is happening because I have not written a code for it. I want this in the 'Access' sheet. Please correct the error and inform me where I have made a mistake so that next time I will avoide it.
Please don't change the 'welcome message code' because I want the message 'welcome' after completing the macro. I don't want vb information in message.
Thanking you in anticipation.

Mukesh