function calls

  1. L

    Pushing or pulling data between worksheets?

    Here's a remarkable problem concerning function behaviour of functions when used between worksheets. I've not been able to explain or solve it up to now, despite looking in several books and consulting this and other Excel forums. It is easy enough to define a macro sub on worksheet S (source)...
  2. T

    Get ReturnValue as a numCells to loop subroutines

    I am looking for a way to pass the ReturnValue of n from function as a numCells to loop a subroutine like so, Call nameSub(n). Is this possible? I want to perform arithmetic on two variables with assigned value. For example: Function mathie(aCur as Integer, preVious as Integer) Dim Cat as...
  3. F

    Run a Function

    Hi, I have function which is formating headers and works OK. Function Header() ..... End Function In sheet1 I added button. How to do that: - if I click on the button function will run and do formating changes?
  4. D

    References between Workbooks when calling a Function

    I am calling a function in workbook B from workbook A. The function call works after I setup a Reference in workbook B (Visual Basic, Tools, References, then select the check box for the Project I want - in this case it's called "X_Steam". This works fine as long as both workbooks are open...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top