| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
my code is adding single quotes
Try activecell.formula (not .formulaR1C1).
DKY wrote: My code here ActiveCell.FormulaR1C1 = "=VLOOKUP(D" & i & ",kickoutrange,6,FALSE)" that's in my macro is adding a formula that looks like this. =VLOOKUP('D2',kickoutrange,6,FALSE)" when I want it to look like this =VLOOKUP(D2,kickoutrange,6,FALSE)" why is it adding the single quotes around D2? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=392663 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup is adding quotes! | Excel Worksheet Functions | |||
| Adding quotes to columns | Excel Discussion (Misc queries) | |||
| Adding quotes to the ends of a string variable | Excel Programming | |||
| Single quotes in named range | Excel Worksheet Functions | |||
| Magical appearance of single quotes. | Excel Programming | |||
Linear Mode
