Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying 'inches' (") in VB
Hello,
This is a snip from the code I am running on the sheet: If IsEmpty(Target) Then Target = "15" E551 - $300" I want it to return '15" E551 - $300' The problem I am having is the ability to use the inches symbol ("). I get an error when I use this code because visual basic thinks that the " is the end of the value. Anyone have any idea how to get around this? Thanks Sean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
Excel displaying inches not cm | Excel Discussion (Misc queries) | |||
convert column with inches to 2 columns "feet" and "inches" | Excel Discussion (Misc queries) | |||
Convert inches & display as Feet Inches and Fractions -- BUG FREE | Excel Worksheet Functions | |||
How do I display numbers as feet AND inches, as in x'x" ? | Excel Programming |