Adding LastColumn to Macro not working

**capson** · 08-31-2013, 10:56 AM

I am tring to add last column to my SubCleanAll2 but I get "Type Mismatch" at this point in the 2nd Sub

Please Login or Register  to view this content.

I want to start on column H row two or H2

The 1st Sub works the 2nd does not

Thanks

Please Login or Register  to view this content.

**Norie** · 08-31-2013, 11:46 AM

Seems to be a sub/function missing - NumbersOnly.

**capson** · 08-31-2013, 12:10 PM

Forgot to add that part

Please Login or Register  to view this content.

**Norie** · 08-31-2013, 12:19 PM

I can't see why you would get the type mismatch error, probably need to see some data for that.

Don't think it's got anything to do with lastCol though.

There are a few other errors in the code that could cause problems.

For example,

Please Login or Register  to view this content.

here there's no sheet reference for Cells(2,8) and Cells(lastRow, lastCol) so the code will fail unless Sheets(1) is active.

To avoid the problem you can use this.

Please Login or Register  to view this content.

[/code]

There's a similar error on the last line of the code with a similar solution.

What's the purpose of the code anyway?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.