Getting around the Max String size in a vba function?
Posted
by Ommit
on Stack Overflow
See other posts from Stack Overflow
or by Ommit
Published on 2010-03-25T15:12:18Z
Indexed on
2010/03/25
15:23 UTC
Read the original article
Hit count: 347
The max number of characters you can use in string in a vba function is 255. I am trying to run this function
Var1= 1
Var2= 2
.
.
.
Var256 =256
RunMacros= "'Tims_pet_Robot """ & Var1 & """ , """ & Var2 & """ , """ ... """ & Var256 """ '"
Runat=TimeValue("15:00:00")
Application.OnTime EarliestTime:=Runat, Procedure:=RunMacros & RunMacros2 ', schedule:=True
It runs a procedure at a certain time and passes a bunch of variables to it. but the string is too long.
© Stack Overflow or respective owner
