Find "Total Hours" by searching entire rows below selected cell vs. cells in a column

Good evening. I'm using the following code to delete select rows one at a time. I need the last row in the range to remain therefore I prevented the user from deleting the row one up from the row that contains "Total Hours" (which is always in Column B). The code works great as long at the user clicks into a cell in column B. If the user clicks into a cell in column A, C, D, E, F, G, H, or I then the code allows the user to delete the last row.

I believe I need to search entire rows to determine if the row contains "Total Hours" but I can't figure out how to accomplish this feat. Your assistance would be appreciated. Thanks.

Please Login or Register  to view this content.

Matthew

JB,

Thanks for chiming in. I gave it a whirl and no dice. In the event I placed your suggestion into my code incorrectly, here's where I placed it (see below).

Please Login or Register  to view this content.

Matthew

John,

The additional lines of code work great to limit the user to column B. I've got an odd behavior occurring that I did not detect in my previous trials. When I select a row to delete in one range a row in the range below the range I've selected deletes. Ugh. Off to problem solve. Thanks for pointing me in the right direction with regards to the code you provided.

Matthew

John,

I figured out what is happening. The cell that was selected BEFORE clicking the Delete Client command button is the cell that is deleting and not the cell that is being selected AFTER the Delete Client command button is clicked. Here's what I've come up with and it seems to be working okay now. Thanks again.

Matthew

Please Login or Register  to view this content.