call function

Hi Everyone, Not sure if this can be answered easily but here it goes: I've created a module in VBA where I've placed a sub macro containing: Sub BG_UpdatingOFF() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual End Sub Sub BG_UpdatingON()...

Hi, I know that you can use a chart click event to do this, but i just cannot get it to work. What i need to do, is by clicking on a chart series, i can get the chart point name input into a cell, say a2. I think the code below if fine, i just dont know how to enter the correct things after...

Sub Button4_Click() Dim n As Integer n = Range("M4").Select Call LaunchWEST("abx.Ins:& n &", "0", "") OK so the range is an integer with SIX to Seven Digits and I want it the button to take this string from a Cell and Launch a function LaunchWEST, when the string is selected and completed...

Sorry for the stupid question, but it seems the mistake is when I'm trying to call the function for the calculation. I do not do it the proper way i guess, and i get crazy results, or no results. How is the correct way for the below procedure? Option Explicit Dim EFCO2 As Long, CO2em As Long...