VBA Compiler Problem

XLS Padlock
1

Hi,

I try to use VBA compiler but I couldn’t do it, it always return error
I use the code shown in your example.

VBA Compiler error
VBA Compiler error809×590 124 KB

2

If you want to access Excel objects, you must add Application. before.
In VBA: Range(“A1:A4”).Value = 2
In compiled VBA: Application.Range(“A1:A4”).Value = 2
See the explanation here:
https://www.xlspadlock.com/doc/accessing-excel-objects-from-com.html