Help with Quotation Mark.

**bbmak** · 06-10-2014, 08:15 PM

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

Cells(i, temp1lastCol + 6).Formula = "=text(""" & invoice + i - 2 & """, ""Rept(0, """ & invoiceLenCount & """)"")"

Thank,

**6StringJazzer** · 06-10-2014, 09:02 PM

Try this one:

Formula:

Cells(i, temp1lastCol + 6).Formula = "=text(" & invoice + i - 2 & ", Rept(0," & invoiceLenCount & "))"

**bbmak** · 06-11-2014, 11:59 AM

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

**shg** · 06-11-2014, 12:14 PM

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

Sub x()
    Dim temp1lastCol As Long
    Dim invoiceLenCount As Long
    Dim invoice     As Long
    Dim i           As Long

    temp1lastCol = 1
    invoiceLenCount = 27
    invoice = 42
    i = 2

    Cells(i, temp1lastCol + 6).Formula = "=text(" & invoice + i - 2 & ", Rept(0," & invoiceLenCount & "))"
End Sub

Are all the varables appropriately declared and initialized?

**bbmak** · 06-11-2014, 12:29 PM

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

Help with Quotation Mark.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Help with Quotation Mark.

Re: Help with Quotation Mark.

Re: Help with Quotation Mark.

Re: Help with Quotation Mark.

Re: Help with Quotation Mark.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Quotation Mark Problem?

[SOLVED] Can't enter a quotation mark using the quotation key into an excel formula or cell

Quotation mark?

Quotation mark (") conversion

how do I concatenate text that has a quotation mark

Bookmarks

Bookmarks

Posting Permissions