MrExcel HTML Maker type missmatch error

[Biggy]

Hello,
Some of the forum members recommended to use MrExcel HTML Make, instead of screenshots and I totally understand why. I tried to get it to work, but when I tried to run it, it gave type missmatch error. Maybe it's because I am using excel 2013?

Below are two images: in 1st is error itself, 2nd one is with line where this errors debugger takes me.

Missmatch Error:

Line in the VBA code:

Hopefully someone will be able to help me with this error. Thank You very much!

Sincerely,
Biggy

 

[shg]

What does

? Application.Version

return when entered in the Immediate window?

 

[Biggy]

What does

? Application.Version

return when entered in the Immediate window?

It returns 15.0

 

[RoryA]

Try changing CLng to Val.

 

[Biggy]

Try changing CLng to Val.

Hello,
After changing CLng to Val it's creating a code, but when I past it into a forum, it isn't making any table, but is just a plain text.

Sincerely,
Biggy

 

[RoryA]

Which forum are you pasting to - they don't all run HTML.

 

[Biggy]

Which forum are you pasting to - they don't all run HTML.

Thank You! You was completely right!