Ask Experts Questions for FREE Help !
Ask
    Anj999's Avatar
    Anj999 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 23, 2009, 03:32 AM
    No Error in Code but clicking button gets no response
    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.

Check out some similar questions!

Java virtual machine launher error when clicking shortcut [ 1 Answers ]

Hi I am trying to launch an applcation called word shark4. This is supposed to run from the network. When I click the shortcut icon it comes up with the following error. Could not find the main class. Program will exit. I have checked all the permissions on the files and they are correct...

Error code 31 [ 7 Answers ]

I have a carrier furnace flashing error code 31 which states: 31-Pressure, draft safeguard, or auxiliary limit (when used) switch did not close or reopened. How do I fix it?

Email error response and how to fix it? [ 1 Answers ]

The host 'smtp' could not be found. Please verify that you have entered the server name correctly. Account: 'http', Server: 'smtp', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 11001, Error Number: 0x800CCC0D I'd like to know how to fix this response?

Cannot open links that require clicking on a "submit" button [ 6 Answers ]

I am not able to open links that require clicking on a button to access. My computer tries to open but what results is a blank page is displayed for a minute and then it just goes back to the original page that I start from. This happens in email as well as on direct web pages. Sometimes it...

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.