Hey guys, I need a small help,
I want to clear Range A2:F2 automatically when the excel file is closed and reopened.
I am using Rangr A1:F1 to filter cells.
So i want it to clear the range A2:F2 automatically when file is closed.
Currently I have this code to filter cells:
The 2nd part of the code auto clears range A2:F2 when i change my page.
Please Login or Register to view this content.
I have attached my code in Post 3. Please do have a look
Last edited by anilpatni1234; 04-21-2019 at 06:46 AM.
In your file in sheet "PRODUCT" in range "A2:F2" there is no data ...!
Is it the right range ???
Else in a module put
Please Login or Register to view this content.
Last edited by PCI; 04-21-2019 at 05:23 AM.
- Battle without fear gives no glory - Just try
Hey PCI,
thank you so much for your reply.
i have updated my file. Please do have a look.
In cell "A2" i have data "2" written on it.
Now what I want is that if i close this file , and reopen this file, then I want it to auto clear range A2:F2.
Basically i want to clear the range A2:F2 everytime i open the file
Basically i want to clear the range A2:F2 everytime i open the file
Yes this the job of Sub Auto_Open()
Last edited by PCI; 04-21-2019 at 07:04 AM.
Hey PCI,'
If i type "2" in cell "A2", then it filters the sheet , column "F" with "2" and hance shows the filterted results.
the code which you mentioned , clears the range whenever I open the file again but it does not show the other data in the sheet. It stays in filtered mode. So i need to press "backspace" button in my keyboard in cell A2 to show the other data .
How can we fix it? i want the code to clear the cell contents and ulfilter it also.
See how nextcode works ...!
Please Login or Register to view this content.
Hey PCI,
it is not working . I tried it. I have attached workbook . Please do have a look if i did it right.
I have uploaded my file .
Thank you
Okay, let's do it more simply
Please Login or Register to view this content.
Hey PCI,
the code works perfectly.
However if there is no data in range A2:G2 and i close the file. And open the file again then i get this error : (i have uploaded the image)
Please do have a look
Here again
Please Login or Register to view this content.
Hey PCI,
the code works perfectly now.
thank you for all your valubale time and help.
It means a lot.
Thank you
You're welcome
Happy Easter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks