nonblank cells

  1. P

    VBA Copy NonBlanks from Range to other range

    Hi, I have looked at a few codes and tried to put them together (crudely admittedly) but have gone wrong so hoping someone could point out my error! I have a sheet with a list of tab on in Range I2:I23 as it can vary. I want a code to check each tab on two ranges, C5:H79 & C86:H160 and copy...
  2. H

    non blank cells

    I have a must requirement that if A1 has data, B1 should be either / or some other user defined text but should never be blank. This is just an example, I would also like to extend the logic to complete list e.g. from A1 to A25 and so on. Trying data validation and some macros already discussed...
  3. A

    Count Question

    Hello, I have a list of data that is generated from a formula. The formula either returns a number or a " ". I need to get a count of the numbers in my list. However, all count formulas (Count, CountA, CountIf) include the cells that contain " " even though no number is in that cell. Is...

Watch MrExcel Video

This Week's Hot Topics

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
Top