If the emp nr is top left corner,
range(activecell,activecell.Offset(12,1)).EntireRo w.delete
should work

"Greg Little" wrote:

Hello, all-
I'm trying to select and delete a range of cells, based on one cell
contained within the range. Can someone suggest a remedy? Basically, it is from
a time sheet for multiple people, and each person is a 12 row by 15 column
range, repeated down the worksheet. I want to select the employee's number,
delete that person's range and close up the remaining cells. Thanks in advance,
I'm pretty frustrated right now.

Greg Little
glittle.at.sprynet.com