Results 1 to 13 of 13

Calculation using Macro ( MS Excel 2007 )

Threaded View

hally Calculation using Macro ( MS... 01-06-2008, 08:59 PM
shg Option Explicit Sub... 01-06-2008, 09:40 PM
hally Thank you shg.. But it... 01-06-2008, 09:59 PM
shg hally, your code is wrong; my... 01-06-2008, 11:12 PM
Paul Hi Hally, try this code... 01-06-2008, 11:42 PM
  1. #1
    Registered User
    Join Date
    12-12-2007
    Posts
    33

    Unhappy Calculation using Macro ( MS Excel 2007 )

    Good day..

    I want to do simple calculation using Macro in MS Excel 2007..

    All the data is in Sheet1 ( Which is 13a ), the calculation is in Sheet2 ( Which is work ) and the result of the calculation will come out in Sheet3 ( Which is result ).. Here is my coding..

    Sub cmdOK_Click()
    Dim xl_result, xl_13a, xl_work As Worksheet
    Dim oper
    Dim valueO
    
    
    'Dim cellW As Range
    
    'sheet13a = Sheets("work").Range(F6).value
    'sheetR = Sheets("work").Range(G6).value
    Set xl_work = Sheets("work")
    Set xl_13a = Sheets("13a")
    'xl_work.Select
    
    'oper = xl_work.Range("C6").value
    'valueO = xl_work.Range("D6").value
    valueO = 2
    '
    'a = 5
    'i = 5
    'strjcn = "'"
    'rw = 2
    'CNT = 1
    'Status = ""
    
       
    
    'xl_result.Select
    xl_result.Range("E6") = xl_13a.Range("E6").value + valueO
    
    End Sub

    Here is my attachment.. Maybe some of you can help me..


    Thank you so much for your kind help..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1