function parameters

  1. K

    How to pass a User defined type as a function parameter

    I use VBA all the time but have never tried to use Type. I haven't quite figured it out. Not sure how to pass the parameter into a function. Basically i have a function that i want to call to find a value in a range based on a condition. The condition is a type and based on the type i will find...
    • Kmanbozzy
    • Thread
    • boolean function parameters type user defined type vba
    • Replies: 2
    • Forum: Excel Questions
  2. C

    range error with worksheet object

    I'm having a problem with a sub for shading a row. I started by recording a macro, then generalizing it as below: Sub ShadeRow(aSheet As Worksheet, row As Long, nCols As Integer, blueFlag As Boolean) ' ' Shade iRow X cols blue or green ' With aSheet.Range(Cells(row, 1), Cells(row...
    • cahinton
    • Thread
    • end function parameters range range method error worksheet
    • Replies: 2
    • Forum: Excel Questions

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