I can use that but if I have that formula it create blank cells which i don't
want. If I have 5 active cells in AC I only what 5 values in AB so my
database doesn't have empty rows.


"Phuelgod" wrote:

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?