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)...
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...
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?
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 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.