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]

I suspect the OP means recording.

 

[tuanmaciek]

Maciek

What do you mean by 'registering'?

I meant recording ?

 

[Norie]

What where you doing in the workbook when you recorded that code?

 

[tuanmaciek]

What where you doing in the workbook when you recorded that code?

Those were random actions just to show this situation. The purpose was to hide column "I" and then insert and delete some rows.