I'll take another look, I've been reallybusy
I've nearly finished. Hopefully I'll have it completed by tomorrow.
Take your time and thank you
I think this is what you want
This is exactly what I need, I will study your change since it corrects
the problem I was having.
As you can readily see, I am weak in the new indexing technologies,
although I understand the logic, I lack the new expertise in the code
syntax as well as its application.
Needless to say I will keep informed of my progress and will share
my new findings and/or developments with you and whoever else
you deem that could benefit from my learning experience.
Again, grateful for your efforts,
Pleased to help
The intent of the code below is to eliminate empty rows using the sort function. I am trying to do this by setting to zeroes a date field which is the only field in the row with significant data.
I used various functions that should've done what I am trying to accomplish. The results of the execution of this code is that it does not set to zeroes the date field so the sort function does not delete the rows in question.Code
Thanks again for providing your help and expertise.
Can you please read the Forum Rules and always use Code Tags when posting code on the Forum.
Is this a different problem?
Roy, this code relates to the same problem. I am simply exploring other functions that could be applicable to what I am doing/learning.
I've created a list of cells extracted from the calendar and I am trying to establish the conditions for the sort function to delete non-significant rows automatically. I believe this could not be achieved if I do not set the date field to zeroes, being the only significant field in the rows.
From now on I will be using the code tags, I've read rules before about the code tags, my problem is that I have an ailment called retinopathy (bad eyesight) and could not find the Icon for it, sorry.
If you need the complete set of code I will provided for you.
Thank you, Jack
Yes this is a nasty condition, but I do not complain, although with certain difficulty some times, I still can see,
there are people that are less lucky than me.
I already found the code tag Icon, thanks for you kind offer. As always, I can wait for your analysis of this situation whenever you can, if you need the rest of the code, I will provided using the tag code.
Again, thanks for your help.