try this idea for ONE line
ActiveCell = ActiveCell & Application.CountIf(Range("c3:c33"), "ccc")
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: mburkett
Sent: Friday, August 31, 2012 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Combi
Ojemeni Uzoma | Call 08060700717
-Original Message-
From: Paul Schreiner
Sender: excel-macros@googlegroups.com
Date: Fri, 31 Aug 2012 10:04:52
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Combining variables with Excel Formulas
Your result is exactly what
Your result is exactly what you told Excel to do.
when you put something in quotes ("), you're telling Excel to "take this string
LITERALLY"
and do not "evaluate" the string.
So you basically said to set the cell value to the value of 'indname' and
append a string.
You might as well say:
activec
