Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert formula into a cell doesn't work :S
If got this piece of code: For x = 5 To 10 Range("D" & x).Formula = "=COUNTIF(PEN!$G:$G;$B" & x & " & \"CO\")" Next x Should result in: =COUNTIF(PEN!$G:$G;$B5 & "CO") in cell D5 ... =COUNTIF(PEN!$G:$G;$B10 & "CO") in cell D10 But it doesn't do the trick... someone who knows how to make it work?! Thanks in advance!! Steven -- s80NL ------------------------------------------------------------------------ s80NL's Profile: http://www.excelforum.com/member.php...o&userid=36374 View this thread: http://www.excelforum.com/showthread...hreadid=572699 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert formula into a cell doesn't work :S
"s80NL" ha scritto nel
messaggio ... If got this piece of code: For x = 5 To 10 Range("D" & x).Formula = "=COUNTIF(PEN!$G:$G;$B" & x & " & \"CO\")" Next x Should result in: =COUNTIF(PEN!$G:$G;$B5 & "CO") in cell D5 .. =COUNTIF(PEN!$G:$G;$B10 & "CO") in cell D10 But it doesn't do the trick... someone who knows how to make it work?! Thanks in advance!! Steven Hi Steven, try without the slash, so you will have: Range("D" & x).Formula = "=COUNTIF(PEN!$G:$G;$B" & x & ""CO")" -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert formula into a cell doesn't work :S
Sub a()
For x = 5 To 10 Range("D" & x).Formula = _ "=COUNTIF(PEN!$G:$G,$B" & x & "&""CO"")" Next x End Sub Also, note that I use a comma instead of a semicolon. When you use Formula, you should enter the formula using US English conventions. -- Regards, Tom Ogilvy "s80NL" wrote: If got this piece of code: For x = 5 To 10 Range("D" & x).Formula = "=COUNTIF(PEN!$G:$G;$B" & x & " & \"CO\")" Next x Should result in: =COUNTIF(PEN!$G:$G;$B5 & "CO") in cell D5 ... =COUNTIF(PEN!$G:$G;$B10 & "CO") in cell D10 But it doesn't do the trick... someone who knows how to make it work?! Thanks in advance!! Steven -- s80NL ------------------------------------------------------------------------ s80NL's Profile: http://www.excelforum.com/member.php...o&userid=36374 View this thread: http://www.excelforum.com/showthread...hreadid=572699 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a formula into the last row of a cell | Excel Programming | |||
Insert Formula in Cell with VBA | Excel Programming | |||
Using VBA to Insert a formula in a cell | Excel Programming | |||
Insert value of formula into cell | Excel Programming | |||
insert formula in last cell | Excel Programming |