range.cells

  1. L

    Clear all cells (cells.clear)

    Hi to clear all cells I can write this code Sub clearall() Cells.Clear End Sub I used object browser and found that cells is a property of 3 objects Application.Cells Range.Cells WorkSheet.Cells So my question, which one I am using when I say Cells. Clear? Thank you
    • lezawang
    • Thread
    • cells cells.clear clear range.cells worksheet.cells
    • Replies: 1
    • Forum: Excel Questions
  2. P

    General VBA question - Range.Cells

    Hello everyone, I got into discussion with my friend a couple of days ago in regards to Range.Cells and its usage. How I understood this method so far is that, if for example you have Range("A1:C3") and you say Range.Cells(2,2) it would refer to second row second column in my range, which...

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