Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif declaration problem with ""word""
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif declaration problem with ""word""
Worksheets("promotion").Range("L22").Formula _
= "=COUNTIF('Database'!$AR" & x & ":$AR" & y & ",""T-shirt"")" You have to double up those double quotes. mpot4 wrote: 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. -- mpot4 ------------------------------------------------------------------------ mpot4's Profile: http://www.excelforum.com/member.php...o&userid=27418 View this thread: http://www.excelforum.com/showthread...hreadid=474924 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif declaration problem with ""word""
try
Worksheets("promotion").Range("L22").Formula = _ "=COUNTIF('Database'!$AR" & x & ":$AR" & y & ",""T-shirt"")" "mpot4" wrote: 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. -- mpot4 ------------------------------------------------------------------------ mpot4's Profile: http://www.excelforum.com/member.php...o&userid=27418 View this thread: http://www.excelforum.com/showthread...hreadid=474924 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |