LinkBack URL
About LinkBacks
I have a column of cells that have a formula in them to return a value or "" (blank)
how would I write a line of VBA to pick the list of cells but not the blanks (this range would be contagious)
I have a column of cells that have a formula in them to return a value or "" (blank)
how would I write a line of VBA to pick the list of cells but not the blanks (this range would be contagious)
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
What type of data is in the column?
How contagious is the range?
If posting code please use code tags, see here.
the formula in the cell is
=IF(B4="","",D4+E4)
all the way down for 1000ish rows
by contagious I just mean the list will always be
value
value
value
value
value (until blank then)
blank
blank
blank
blank (for the remainder)
bump please
So you mean it's contiguous rather than contagious?
Is it numbers in the column?
Which column is it?
Last edited by Norie; 12-03-2012 at 10:08 AM.
yes sorry my mistake.
as for the column it will be on several columns (which is why I need the general principle to apply to more)
the column is F in this case and the value in the cells will be numbers up to approx 1000
Hi -
Is the filter method not applicable?
Regards,
Event
nope i need to have a few things done all in the click of a button (its not for my use but someone with no excel knowledge so the less they do the better)
Hi -
Post a sample file showing before and after.
Regards,
Event
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks