cell type

  1. J

    Divide by zero error - how to find solution

    I am trying to work a very simple spreadsheet for student averages. Some columns have text, but I know that the average function is supposed to ignore text. When I use the average function of =AVERAGE(B2:H2), it gives me the #DIV/0! error. So I rewrote the formula to only include the columns...
  2. FracinDean

    Determing Cell Type Contents

    Hello Mr. Excel Forum, I'm trying to use VBA to test whether a worksheet cell is blank, contains a formula, or contains a value that is not a formula. I found a cell constant called x1CellType in the VBA help system, but the help information about x1CellType was useless to me. I suppose I...
  3. S

    Check for Picture in a cell

    Each month I receive a spreadsheet from another office. From it I extract certain data. I have created a macro to loop thru and do this. The problem is, some cells contain both a picture and text. I need to ignore those cells. I need a way to determine if a cell contains a picture. The only...

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