No Error in Code but clicking button gets no response

Anj999 · #1 Aug 23, 2009, 02:32 AM

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.