select empty cells

  1. dakota727

    Using Go to Special to select all balnk cells including merged cells

    Does anyone know of an easy way to select all empty cells in a worksheet using VBA. I wanted to take a protected sheet and use VBA to unprotect it. Then unlock all the cells on the sheet that are empty and then re-protect the sheet. I was using the Go To Special feature but found out it will...
  2. N

    Select all empty cells

    I like to colour all empty cells in excel applets, so that the borders can not be seen anymore and the used cells and tables can be seen easily. But therefor I allways have to select all cells, colour these and then recolour the cells with a content. This takes quiet a lot of time, so I wonder...

Some videos you may like

This Week's Hot Topics