NO VBA ‘OBJECT’ & ‘MODULE’ Folder SHOWING

I am not able to see “VBA OBJECT” folder & “VBA MODULE” folder under VBA PROJECT heading in VISUAL BASIC EDITOR Window. Also when i write a code , i am unable to run it.Below is the Code:-

 

Sub ROWSELECTION_FILTER()

 

Dim rownumber As Integer

 

rownumber = ActiveCell.Row

 

    If Application.Intersect(ActiveCell, [Headers1]) Is Nothing Then

 

        If ActiveCell.Value <> “” Then

 

        Range(“a6” & rownumber & “:v5000” & rownumber).Interior.Color = RGB(255, 255, 9)

 

        End If

 

    End If

 

End Sub

By: naresh

Leave a Reply

Your email address will not be published. Required fields are marked *