Ask Experts Questions for FREE Help!
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps
 
Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  Answer this Question    Ask about Visual Basic    Ask about another Subject  
 
PDA

Anj999
Aug 23, 2009, 03: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.