Hello everyone,
I have attached an excel file which contains a macro.
What i am trying to do is this:
When i run the macro it will ask for Start date and End date .
Then it will delete all rows for dates < Start date and > End date.
Till here it is working fine.
Problem is :
I want to do error check ie.
if the user keeps the Start date or End date blank
OR
if End date < Start date
OR
if CANCEL button is clicked
what should be done ?
Pls help
Regds
Kmahesh
Please Login or Register to view this content.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thanks Haripopuri & Patel45 ,
both the solutions are working
Glad we could help. You might consider showing your respect to the person who helped you by clicking on star button at the bottom of the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks