Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"ByRef argument type mismtach" on string variable *sometimes*
I am using the code at http://www.vbaexpress.com/kb/archive.php/k-743.html
to change the color of some text in an Excel 2003 spreadsheet. I am using the following type of invocation: Dim TargetString, OtherString As String TargetString = "QuickBrownFox" Call xlCellTextMgmt( SomeCell, _ TargetString , , , , , ColorIndexRed ) This generates the error in the subject line. However, this invocation is fine: Call xlCellTextMgmt( SomeCell, _ "QuickBrownFox", , , , , ColorIndexRed ) This invocation is fine, too: OtherString = "QuickBrownFox" SomeCell = OtherString Call xlCellTextMgmt( SomeCell, _ OtherString, , , , , ColorIndexRed ) What could possibly cause the first invocation to give the subject error? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"ByRef argument type mismtach" on string variable *sometimes* | Excel Programming | |||
"Compile Error: ByRef argument type mismatch" when calling my function from another module | Excel Programming | |||
HELP "ByRef Argument Type Mismatch" | Excel Programming | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
"ByRef argument type mismatch" Error | Excel Programming |