| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quote Marks Through VBA
Very simple question, but I can't figure it out:
I want to make a formula in a cell through VBA, but I want the formula to have a word in it (which needs to be in quotes). That is, I want the formula to read: =IF(Sheet2!G6="Maturity",1,2) How can I get the Maturity part surrounded by quotes? Thanks! Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slash marks in dates | Excel Discussion (Misc queries) | |||
| Formula - Marks in Group | Excel Discussion (Misc queries) | |||
| Pease help with a formula to select 7 best marks out of 12 | Excel Discussion (Misc queries) | |||
| how can i trace position in marks sheet | Excel Worksheet Functions | |||
| Y-axis tick marks in middle of chart? | Charts and Charting in Excel | |||
Threaded Mode
