I have dabbled in programming and have checked out what other have sent, but I am still having problems getting all of it to work. Here is my problem

I have a range of cell, B6, D6, F6, H,6, J6, L6, N6, P6 which I have made into a range. (This range will most likely be extended to cover rows 6-41 if possible) I would like to be able to create a macro that check the active cell within that range and see if a comment exitsts, if it does not, then pop open a textbox for adding a comment

I have a macro that works on a specified cell but not from a range. I know this is over my head but this is how we learn, is it not? Any help will always be much appreciated.