ActiveX components can't create objects

Dim X, Y
The Set X=CreateObject (" Excel. Application. Range ")
The Set Y=CreateObject (" Excel. Application. Range ")

The If levels. On 1. Caption=Level. Cells (X, 1) Then
X=ActiveCell. Row
End the If

The If levels. ChapterLabel=Level. Cells (1, Y) Then
Y=ActiveCell. Column
End the If

I watched the F2 Excel. Application. The Range the referenced DAO3.6 I have loaded & gt; . & lt;

CodePudding user response:

Did excel/office installation, is the full version

CodePudding user response:

There is no such object Excel. Application. Range
Are so with Excel. Application

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,