Hi,
I'm trying to figure out why a simple IF statement using a range name isn't working:
The line in bold always blows up. What am I doing wrong?Please Login or Register to view this content.
Lawrence
Hi,
I'm trying to figure out why a simple IF statement using a range name isn't working:
The line in bold always blows up. What am I doing wrong?Please Login or Register to view this content.
Lawrence
Last edited by skysurfer; 07-29-2010 at 06:06 PM.
It's a multi-cell range. You can't compare an array to a single value.
Entia non sunt multiplicanda sine necessitate
shg,
Thanks.
But then how do I write the formula so that it the macro executes when the item count in the range "ListItemsCount" is greater than 0?
Is the only way to have the range name refer to only one cell?
Lawrence
My mistake, ListItemsCount is not a range, it's a value.
You need to do a better job with thread titles, please. Read the part about "concise."Please Login or Register to view this content.
shg,
THANKS!
As for the title, will do...and post the updated file for future reference.
Lawrence
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks