macro clear cells s#'s

  1. smide

    Macro ClearContents specified range cells on multiple Workbooks

    Hello. I'm currently using the following code to clear cells in a Sheet2: Option Explicit Sub Clear() Worksheets("Sheet2").Range("A1:Z50").ClearContents End Sub However, since I have about 30 Workbooks (all in the same folder) I would like to clear contents in all of them (range A1:Z50...
    • smide
    • Thread
    • macro clear cells s#'s vba & excel 2007
    • Replies: 1
    • Forum: Excel Questions
  2. O

    Clear Cells with #'s Plz hlp

    I have 4 columns A,B,C,D thousands of rows Column B: has some data that is #'s only (not important) ........................so i need to empty those cells with #'s only in that column any macros? thanks in advance Steve G:confused:

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