Syntax Error when Compiling VBA

XLS Padlock
1

I am receiving a syntax error when trying to compile my macros. I do not understand the problem with this macro. I receive no errors within Excel, only within XLS Padlock.

image
image1366×768 130 KB

I get a similar error on all of the macros I have tried to compile.

Please help.

2

For Each Cell isn’t supported by the VBA compiler. For loops must be in this format:

image
image705×534 37.6 KB

3

I am sorry to be dense, but I am new to VBA. I do not understand what you are telling me to change in my code.

Can you tell me what I need to change specifically?

4

For instance:

Dim i As Integer
For i = 1 To WorkRange.Rows.Count
     WorkRange.Cells(2, i).Value = ""
Next
5

Here’s what I tried and it errors out on the (WorkRange.Cells(2, i).Value = “”) line

Dim WorkRange As Range
Dim i As Integer
Set WorkRange = ActiveSheet.UsedRange
For i = 1 To WorkRange.Rows.Count
    WorkRange.Cells(2, i).Value = ""
Next

End Sub

6

Do not forget to use Application for Excel-related objects (see our user guide):

Dim WorkRange As Range
Dim i As Integer
Set WorkRange = Application.ActiveSheet.UsedRange
For i = 1 To WorkRange.Rows.Count
    WorkRange.Cells(2, i).Value = ""
Next