more than one

  1. A

    from nothing to more than 1.

    Hello everyone, I want to ask how I can change this line from nothing to more than one. Everytime I try it doesn't seem to work. If Not rng Is Nothing Then rng.Interior.Color = vbRed Thanks a lot for helping me (Here is the line of code of code where it is used in) Sub Kijken_2() Dim...
  2. A

    Lookup based on two criteria

    Hello I have a problem. I have two tables in Sheet 1 and Sheet 2 of a workbook. There are 3 fields in each of the tables out of which Name and Date are common in both the worksheets with varying data. Now I want to function which matches the name and date with the hours worked on that date by...
  3. B

    More than 1 name for a range

    I use named ranges a lot both to identify particular ranges on a sheet, and as markers to identify certain properties of a sheet so that when an auto command happens, it can tailor what it does for the sheet. I have got to the stage whereby I cannot rely on a range - or individual cell - not...

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