Error in ColumnWidth Code

**nordicdust** · 12-13-2018, 12:23 PM

Hi Guys,

Any chance there is someone that can help me get this right?

Please Login or Register  to view this content.

**rorya** · 12-13-2018, 12:27 PM

Where is ColumnsWidth supposed to get its value? Is it even necessary, given that you aren't using it in the code? (it's not clear if you meant to, or if you just want the current width increased by 5)

**than_gold** · 12-13-2018, 12:28 PM

Here you go, spell mistake in declared variant.
use Option Explicit at begining of the module, to prevent these errors.

Please Login or Register  to view this content.

**nordicdust** · 12-13-2018, 12:33 PM

I just want the current width increased by 5

**nordicdust** · 12-13-2018, 12:36 PM

I have "Option Explicit " at the top of the Module, and I get no Errors when debugging?
I corrected the spelling mistake.
Udklip.JPG

**rorya** · 12-13-2018, 12:37 PM

Then all you need is this:

Please Login or Register  to view this content.

**nordicdust** · 12-15-2018, 05:20 AM

Thanks rorya

It still gives me an Error!
I have attached the workbook and a picture, maybe I am missing something.
I the odd thing is, it works if I run any other macro first?? Udklip.JPG