go to special

  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. already

    go to special blank cells

    Hi I have a lot of formulas in (if(xxx;"")) column A. Some of those results in nothing (blank cells). I did a copy > paste special > values to column B. After that I have selected column B > go to special > Blanks. And I received a message that no cells are blank (nothing is selected). I can...

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