Have you tried using:

If activecell.offset(0,1).Value<"" then

Where activecell is the cell in column AB?

--
Frank

"Do or do not; There is no try"
-Yoda


"Joe" wrote:

I have data elements in cols AC:AF. Data will be in rows from 5 to whatever.
I need to add a value from another named cell in the worksheet into col AB.
How do I do it so I only add values in AB that have data in AC?