| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to refer to a text piece in a VBA custom function?
I have created some custom functions but am confused how to refer to a piece
of text in the code e.g.: ...." & ABC.Address & "=A How can I refer "A"? because two inverted commas wouldn't work as: ...." & ABC.Address & ""=A" Thanx in Advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to refer to a text piece in a VBA custom function?
Maybe...
...." & ABC.Address & "=A" But I don't really understand what you want. FARAZ QURESHI wrote: I have created some custom functions but am confused how to refer to a piece of text in the code e.g.: ..." & ABC.Address & "=A How can I refer "A"? because two inverted commas wouldn't work as: ..." & ABC.Address & ""=A" Thanx in Advance -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to refer to a text piece in a VBA custom function?
Try
...." & ABC.Address & "=""A""" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "FARAZ QURESHI" wrote in message ... I have created some custom functions but am confused how to refer to a piece of text in the code e.g.: ..." & ABC.Address & "=A How can I refer "A"? because two inverted commas wouldn't work as: ..." & ABC.Address & ""=A" Thanx in Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two hyperlinks in 1 piece of text? | Excel Discussion (Misc queries) | |||
| Worksheet function to refer to columns by number | Excel Discussion (Misc queries) | |||
| How can I refer to a worksheet using text in a cell? | Excel Discussion (Misc queries) | |||
| Custom number formats in TEXT function | Excel Worksheet Functions | |||
| How to move one piece of text to another column | Excel Discussion (Misc queries) | |||
Linear Mode
