VBA ISSUE

[MikeDBMan]

I am running the same VBA code I have for several years. All of a sudden I started getting "Run-time error '1004': Method 'Range' of object '_Global' failed. The code it was executing was:

Range("B4").select

I suspect it may have something to do with a recent auto-update and maybe something with the references I am using in the VBA editor. Right now the only Checked references are:
Visual Basic for Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library

I do not know what to do. I have a .xlsa file in the XLSTART folder and have recompiled it. Any suggestions would be greatly appreciated.
I am currently using Excel for Microsoft 365 MSO (16.0.12827.20328) 64-bit. And I am running Windows 10.

 

[Joe4]

Are you sure that cell B4 isn't hidden, protected, or part of a merge cell?

What if you open a new workbook, and just try this simple macro:

Sub Test()
    Range("B4").Select
End Sub

 

[MikeDBMan]

Are you sure that cell B4 isn't hidden, protected, or part of a merge cell?

What if you open a new workbook, and just try this simple macro:

Sub Test()
    Range("B4").Select
End Sub

I tried that. It worked fine. Several other files seem to work fine. I am going to reconstruct the offending file and see if that solves my problem. A lot of work involved unfortunately.

 

[MikeDBMan]

I seem to have solved the issue. I moved the file to my hard drive, exported he 2 VBA modules. Added the VBA modules back in. It seems fine now.

 

[Joe4]

Glad to hear it!