CountA does not work

[Templemind]

The issue I have is this: Whenever a new CellX that is not found on ws2 an error of Error 1004 Application defined or object-defined error on the last part of code: "ws2.Cells(emptyRow, emptyCol).Value = DateAdd("d", -1, Date)" keeps popping up. It still enters the data the way I want, but the rest of the code doesn't run after that error comes up. When I take that part of code out, it works without having any errors, but it does not add the date in the empty column beside Res.

I hope this makes sense with the code I provided. Is it something with the emptyCol= function?

Please Login or Register  to view this content.

[:) Sixthsense :)]

Can you please explain what you are trying to do with this line of code?

Please Login or Register  to view this content.

It should be

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Please confirm

[Templemind]

I tried looking up the arguments for CountA, but I could not find it. I was given a variation of this code long ago and am thinking now that it may not be needed.

The Rows(Res) is what is counted. The range is the range of cells to count within

[Norie]

Where are you trying to put the date(s)?

[Templemind]

For a new name (CellX), I want dates in cells 1, 2, and 7. If the name (CellX) is already there, then in an empty column one the same row as the CellX.

[Norie]

I think you need to re-arrange your code a little.

Give this a try.

Please Login or Register  to view this content.

[Templemind]

I see how that makes sense, but my other code that works for me seems to have it arranged in my original way. Oh well.

Thank you for your help. I have been working on this for a while now.