Problems with VBA macro registering

[tuanmaciek]

Hi,

I've got problems with registering macros in Excel VBA. This is a sample macro to hide column "I" instert rows and delete rows. It looks really strange. I've tried Excel fixing I even have removed and installed once again my Office 365. It didn't help.

Sub Makro1()
'
' Makro1 Makro
'

'
    Columns("I:I").Count
    Substitute..Duplicate = TRUE
    Rows("6:7").Count
    Substitute.  := xlDown,  := xlFormatFromLeftOrAbove
    Rows("14:15").Count
    Substitute.  := xlUp
    Range("E9").Count
End Sub

It should look completely different.

Has anyone have an idea what to do?

Maciek

 

[Fluff]

Do you have any add-ins running?

 

[tuanmaciek]

Only Power Pivot and Power Map for Excel.

 

[Norie]

What's 'Substitute'?

 

[tuanmaciek]

What's 'Substitute'?

This is a good question :D. This is original code which appeared during macro registering.

 

[Fluff]

Only Power Pivot and Power Map for Excel.

I wouldn't expect them to cause a problem, but try removing them, restart Excel & then try the recorder again.

 

[tuanmaciek]

I wouldn't expect them to cause a problem, but try removing them, restart Excel & then try the recorder again.

It didn't help .

 

[Fluff]

It's not something I've ever encountered myself, but have seen a few other people posting with similar problems & seem to remember it was something to do with an add-in.
As that doesn't seem to be the case for you, not sure what else to suggest.

 

[tuanmaciek]

It's not something I've ever encountered myself, but have seen a few other people posting with similar problems & seem to remember it was something to do with an add-in.
As that doesn't seem to be the case for you, not sure what else to suggest.

Thanks for interests! It seems as a really tricky challenge

 

[Norie]

Maciek

What do you mean by 'registering'?