Hi there, I am looking for assistance in writing VBA code to do the following.
1) Loop through the first row of every column
2) I want to identify every column where the first row contains the string "rate" in any variation.
3) Select all columns w/ "rate" in the first row and percentage their...
I have a macro that searches for numbers in another sheet and then copies the row it finds it in to sheet 1.
the problem is that some of the search criteria is alpha numeric. i.e 227A, JD190T, etc.
code
Sub copyit()
Dim wsSearch As Worksheet, wsResult As Worksheet
Dim Found As...
Hi
Somebody told me that the NPV formula used by Excel doesn´t calculate the value correctely. Is this true???
I´m trying to calculate the NPV for this cash flow,
Investment: -10.000
1st period 1.000
2nd period 3.000
3rd period 3.500
4th period 4.500
5th period 10.000
Rate: 2%...
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.