What Am I doing wrong here?

Greetings,

On the below code, its breaking at exactly the same spot, I cant for the life of me figure out why.

I get VB 400 error or 1004 error depending on which line you remove the comment ' from

Please Login or Register  to view this content.

I've tried all combinations of the code listed here, commenting out as required.

Its still breaking..

The Message Box indicats the CORRECT formula I am after is being generated.

Any Clues?

Aurbo99

The syntax is Cells (plural)
I can't see why the string based Ranges are erroring, I'd try

Please Login or Register  to view this content.

or changing to this

Please Login or Register  to view this content.

I'm not sure why it isn't erroring with the plus sign.

Thanks Mike,

I've changed the + to an &

the formula still looks correct after that change,

The CStr(k)) had no change in the error.

Hi

Try this.

Please Login or Register  to view this content.

rylo