Reply to thread

Message: [QUOTE="SkippyPB, post: 6656027"] Here's a suggestion assuming you want to ignore a cell if it is empty. Use the LEN function. Something like this: CellLen = Len(Worksheets("Week" & W).Range("U41"). _ Offset(Q)) If CellLen = 0 Then Exit Function W and Q are passed from the calling function but this is just an example of how you could calculate a length of the data in a cell and skip it if nothing is there. HTH. Regards, (o o) -oOO--(_)--OOo- He didn't tell his mother that he ate some glue. His lips were sealed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Remove nospam to email me. Steve [/QUOTE]