Excel Macro indexing problem

Roy,

Take your time and thank you

Roy,

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,

Joaquin Alonso

Hi Roy,

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.

For x = 0 To 10
Range("A1:C1").Offset(x * 1, 0).Select
If IsEmpty(Range("B1:C1").Value) = True then Range("A1").Offset(x * 1, 0).Selection.NumberFormat = "0"
Next

Thanks again for providing your help and expertise.

Jack

Code
For x = 0 To 10
Range("A1:C1").Offset(x * 1, 0).Select
If IsEmpty(Range("B1:C1").Value) = True then Range("A1").Offset(x * 1, 0).Selection.NumberFormat = "0"
Next

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.

Please, advice

Thank you, Jack

Roy,

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.

Jack