empty cell

  1. U

    Null vs. Blank

    I am trying to select all blank cells. im not sure how or why (must be a result of lots of copy/paste) many of my blank cells are not highlighted when I do the function: find>go to special>Blanks>OK not sure how to fix this problem....the spreadsheet is huge and i need to select and delete...
  2. D

    Find empty cell in range and copy range next to it

    I need some help on writing a code that finds any empty cell in a range ("Q4:Q46") and then cuts the cells ("A:P") in that same row and paste it to another sheet starting with cell ("A4"). Then delete the rows that the data was cut from. This code will be linked to a command button. Any help...
  3. H

    Cutting rows based on Column G Macro

    Hey Guys I've been having some problem figuring this one out. I have an excel file with quite a bit of data and I need to be able to cut rows from sheet 1 into sheet 2 based on wether or not column G is blank. (if it is blank I need it moved). Any ideas how VBA handles blank cells? That...
  4. loubeelou

    Error Message

    As an A Level ICT Student, I have been told to push my spreadsheet to as high a standard as I can. I've been asked to find out how to create an Error Message that will show up if a cell is empty when a button is pressed, as we have created an input form type set up. Simple solutions would be...

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