Passing Variable length Space Characters to Variables
Figured it out. Thanks
DesiredLenth = 3
SpaceWidth = ""
For Y = 1 To DesiredLenth
SpaceWidth = SpaceWidth & Chr(32)
Next
CurrentFormulaNoFunction = Replace(CurrentFormula, AllFunctions(X),
SpaceWidth, 1, -1, vbTextCompare)
"ExcelMonkey" wrote:
How do you pass variable length space to a variable. If I want to pass a
space cwith three spaces, I can do it manually by going:
Var = "---" (dashes representing spaces)
But what if the space width is variable in length? In this example I need
to pass the number three to a variable and then use this to define the space
between my quotes that get passed to my Var.
Thanks
|