worksheet functions

  1. S

    Formula will not transfer into VBA

    Hi All! I am trying to put this worksheet function =IFERROR(VLOOKUP(SUBSTITUTE(E2,"/","-"),Master!$E:$E,1,FALSE),VLOOKUP(E2*1,Master!$E:$E,1,FALSE)) Into some VBA code that just drops the formula into a cell and copies it down the length of the data set. For some reason it is throwing me a...
    • Src016
    • Thread
    • formula functions type mismatch error vba worksheet functions
    • Replies: 4
    • Forum: Excel Questions
  2. K

    Worksheet Functions in macro with named ranges

    Good morning all- I'm sure the answer is staring at me in the face, but I've wasted an entire day trying every syntax under the sun. I've also read through many similar posts, but none of the solutions seem to work for my situation. Background: I'm running a macro on a rather lengthy...

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