Add multiple comments to a cell.

I'm making a problem checker for a report that contains 12K rows, and 33 columns. My tentative code is below, which highlights the problem cell. Since my users might not understand why a cell is highlighted, I'd also like, in column AH, to put the problem number, and have a legend at the top, kind of like

1 means there's a PRSTX unit, 2 means an FTE count of Zero, etc.

My problem is that any one row could have multiple problems, so I need a routine to check and see if AH for that row contains a value, and if so put that value, a comma, and the new step number in the cell, otherwise just put the step number. I'd apprecaite some help in making that part, because I'm confused on how to do it.

Please Login or Register  to view this content.

Hi Jomili,
maybe so

Please Login or Register  to view this content.

Nilem,
It's a thing of beauty, but I'm not sure what it is. When I run it, I see that it puts Step1, Step2, etc at the end of the respective rows, but I don't understand how. If it's supposed to replace my code above, it's not highlighting the cells. If if it's meant to run after I finish my code, then sorry if I misled you, but the steps I outlined are just the beginning; there are about 14 steps I envision so far, and maybe more as times goes by, so I need something I can understand, replicate, expand and reuse. So, if you want to guide me through how this thing workds I'd love to learn something new.

maybe it would be clearer

Please Login or Register  to view this content.

Nilem,
Sorry I couldn't get back sooner.

You really rock. Not only do you write good code, you even break it down so simpletons like me can understand it. I can follow what you've done for my other steps. Thank you so much for your help and your understanding!

I spoke too soon. I DID understand how to add steps, but I've had to add a column, so want the Step values to go in AI instead of AH. I changed the range like this, thinking that would do the trick:

Please Login or Register  to view this content.

but it still puts the values in AH. I thought I understood, but apparently don't understand, what Y() is, and don't understand the siginificance to the Ampersand after i& and k&. If you'd care to explain I'd love to learn. My current code is shown below. Thanks,
John

Please Login or Register  to view this content.

found it: sometimes my obtuseness astounds even me. Changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

About "Ampersand after i& and k&". It is an abbreviation for variable types
& means Long (so Dim i& is the same as Dim i as Long)
# - Double
% - Integer
etc.

Sweet! I never knew that. Do you know where I could find a list of the all the abreviated codes like that? I'd like to have a resource to find these things on my own.

Nilem,
I just saw your edit; is that Best Practice because simpletons like me get confused by the shortcuts?