Help with Quotation Mark.

[bbmak]

I basically try to put a formula in a macro, but the I didn't able to get it to run.
I use these 2 formulas
=text(string, "00000"), I put the rept() into the 00000 part.
=rept(0, 6), and I put the invoiceLenCount part into the 6, So, it makes the length of the output based on user input.

the formula works without the sub of Rept() part, but after I put in the Rept part, the macros breaks. Please help

Please Login or Register  to view this content.

Thank,

[6StringJazzer]

Try this one:

Please Login or Register  to view this content.

[bbmak]

Thank for reply, but it is still not working.
I got error message:
Run time error '13':
Type mismatch

[shg]

6SJ's modification works fine for me, e.g.,

Please Login or Register  to view this content.

Are all the varables appropriately declared and initialized?

[bbmak]

Thank,
It works now. And Yes, I mess up one of the Variable declared.