Thanks to those who previously helped me with a few problems. Here is another one.
I am programming a database in which the user can specify a range of rows that should be used in the formula. For example, the user enters for beginning row 10 and for ending row 20, where x will be assigned 10 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 VBA expects the end of some expression. I need -> T-shirt <- to appear in the formula as -> "T-shirt" <- .
How would I be able to assign "T-shirt" as a name, so that it does not cause any conflicts. Thanks for anyone who can give me some advice.
Bookmarks