blank cells

  1. T

    How to find blank cells in a range and the get reference to them

    Can anyone help me please, I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells. And is there a way to only get reference to the row. see image below: I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells...
  2. D

    VBA code or other solution to color cells white if they contain no data

    Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...
  3. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  4. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  5. B

    Inserting ' in blank cells

    Hi, Do you know how to make a code that will enter ' in blank cells in column range A-C? Amount of rows differs in spreadsheets.
  6. M

    Organizing tasks and schedules with forulas

    Hello everyone, I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab. Columns B and C in the calendar look something like this: <tbody> B C proj.1 task 1 (blank) task 2 (blank) task 3 proj 2 task 1...
  7. H

    Highlight Blanks and not "spaces" - conditional formatting

    Hey there, i am trying to highlight if a cell is blank, but don't want " " (a space) to be considered a blank cell. I tried adding a ' before the space, and this doesn't work. Any ideas? isblank and not " "
  8. S

    Returning Formula without blank cells

    I am working on creating a list of students who have not turned in an assignment by staff adviser. I want a list that says Beth, here are your students who have not turned in the assignment. I can get a formula to return the students name by owner, HOWEVER, when a line of data doesn't return a...
  9. K

    VBA If/then. If cell is blank run macro, if not stop.

    Hi... it's been 8 years but maybe someone will see this. I also want to write in VBA, if cell is not blank, then do this. And then stop. Acting only if the cell is not blank... This is based on a column of numbers, updated monthly. So when the month is updated, I want the macro to run. But I...
  10. H

    3 Cell formula calculation based on Dates

    All, I have been working on this formula for a bit and am struggling it to finish it of. I have 3 cells that consist of Date/Time stamp H, I, J: My formula below: =IF(AND(ISNUMBER(J2),ISNUMBER(H2)),(J2-H2)*1440,IF(AND(ISNUMBER(J2),ISBLANK(H2)),(J2-I2)*1440)) But I want to included that if...
  11. S

    Excel VBA to hide rows based on cell value in range

    I am looking for assistance in revising code for one of my worksheets (Sheet3). In essence, I want to look at a specific cell within a range and if that cell is blank, then hide the entire range. Sheet3 has 5 ranges to gauge whether to hide the blank rows and thought a Union would be the best...
  12. F

    #value!

    #VALUE! Error I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F. When I attempt to generate the resulting value...
  13. S

    Due Date, Finish Date

    Hi :) I have a question concerning due dates and finished dates. How would I format the two columns to where if it is complete, the red format I have set up for "expiring soon" goes away? If the order is complete, I'd like for the conditional formatting to correspond. Due date is column D, and...
  14. F

    VBA count Blank Cells

    Hi All I am looking for a little advice as i expect i am going to get a spreadsheet soon with exported data and i wanted to get a head start on a piece of VBA that i'm not aware how to do: So i have the example data below as follows: <tbody> A B C D 1 Name Date Time In Time Out 2 John...
  15. A

    #Value, MODE, LEFT and time of day help, please.

    Hello all - I have been given some great help recently in trying to return the MODE of a series of TIMES (as in times of day). This has been very helpful, and I thank you all. Now I have hit a snag in implementing it. In col C2 I have the following formula: =IF(Main!DG3="X",Main!G3,"") This...
  16. G

    Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    Hi, I require a VBA code to help me remove blank cells across different column labels to reflect the first non-blank cell in each column across unique row labels. This: Has to end up looking like: Where all the duplicated row labels are removed, with only unique values remaining and the...
  17. G

    Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    Hi everyone, This is the sample text. What I require is to remove all the blank cells and lookup the first non-blank cell value as each category for each Name has ONLY one unique value. So this: -- corrupted image removed --
  18. N

    Unidentifiable Non Printing Character

    Hi, I have a spreadsheet which has data imported from a very old excel format (excel 2.0). There are cells in this file which appear blank however excel 2017 does not perceive them as such. The really odd thing here is that if i use F2 to edit the cell and then hit enter or Tab to move off of...
  19. N

    Finding Blank Cells in a Dynamic Range: VBA

    The following code of mine is not running: Sub Blank_Cell_Alert() Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Name = "MyRange" ActiveSheet.Name = "MySheet" If...
  20. T

    Keep Data Going With a Blank Row

    I am trying to get the data to continue numbers while duplicating the previous rows. Then I need it to go over a blank row every 48 or so rows. I need this continuously for over 35,000 rows. Image for help attached - Please note I put in the image how I would like the numbers to keep going...

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