View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Q[_2_] Q[_2_] is offline
external usenet poster
 
Posts: 6
Default Variable-Length String causing error

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