Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i have the following code: Dim Msg As String Msg = Msg & "Award Title:" & Cells(r, 9) & vbCrLf now when i run the marcro, i get the following error: Run-time error '5': Invalid procedure call or argument but when i shorten the title from from 50 characters to about 15 characters it works fine. is there a limit on how many characters a string can have, if not why am i getting this error? any assistance is greatly appreciated, thanks in advance. ~q |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What's causing error message? | Excel Worksheet Functions | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
String length | Excel Discussion (Misc queries) | |||
Sum a column of variable length? | Excel Discussion (Misc queries) | |||
Error when string length 1024 and starts with - | Excel Programming |