fill a variable sized range
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?
|