Runtime Error 13 Mismatch can anyone help

[bloodmilksky]

Hi Guys,

I am having a runtime error 13 mismatch on the below code.

It is meant to utilise the values in column A to create ranges in Sheet 2

can anyone help

1.ConcatenateABandRemoveAllValueswhichwillerror Should run through sheet 1 and create the names for soon to be ranges on sheet2.

2. part of this also removes any random values such as (., spaces, brackets and so on) so as not to cause any conflicts.

3. then it should use the values in A1 to create ranges on sheet2

4. and then copy cells D & E into the range defined in A

5. But it keeps on erroring and I dont know why, as everything that i have put in place should ensure that the ranges dont error.

[cytop]

The error occurs in the 2nd line of

Please Login or Register  to view this content.

in procedure CopySheet1A1toSheet2NextCellInColumnA.

The name isn't defined. It's looking at the header in Col A of sheet1.

You really should learn basic debugging, it's an essential part of writing any code and will save your time.

[bloodmilksky]

HI Cytop,

I am doing my best to learn as much as I can but still at a very early stage of learning VB.

Do you know How I would resolve it?

many thanks

jamie

[cytop]

This error isn't VBA - it's a logic error so no learning required.

Go check exactly what cell it is using (and its contents) to derive the name of the named range.

[bloodmilksky]

now its coming up with a syntax error

[bloodmilksky]

just realised to the name of the range should be defined Column A