Hi,

I am brand new in Excel VBA world and trying to run this code:

Sheets("BS").Range("B38").Offset(0, I).Value = 0
Sheets("BS").Range("B46").Offset(0, I).Formula = "=" & Sheets("BS").Range("B39").Offset(0, I).Address
Application.CutCopyMode = False
End Sub

In code window, I am not getting any error for above code. However clicking the command button on excel spreadsheet gets no response from the application.

I have tried the code by going through line by line (pressing F8) and can see the results I want.

Isn't it frustrating.