Thanks to those who previously helped me with a few problems. Here i
another one.
I am programming a database in which the user can specify a range o
rows that should be used in the formula. For example, the user enter
for beginning row 10 and for ending row 20, where x will be assigned 1
and y will be 20. In the used module the formula goes as follows...
Worksheets("promotion").Range("L22").Formula
"=COUNTIF('Database'!$AR" & x & ":$AR" & y & ","T-shirt")"
Now, the problem lies with the declaration of "T-shirt", where
VB
expects the end of some expression. I need - T-shirt <- to appear i
the formula as - "T-shirt" <- .
How would I be able to assign "T-shirt" as a name, so that it does no
cause any conflicts. Thanks for anyone who can give me some advice
--
mpot
-----------------------------------------------------------------------
mpot4's Profile:
http://www.excelforum.com/member.php...fo&userid=2741
View this thread:
http://www.excelforum.com/showthread.php?threadid=47492