cellrange

  1. D

    how to increment numbers in a range and ignore blanks

    hello, i am trying to increment the cells that hold a numerical value within a range whilst ignoring blank cells. i am using the code below, but it has no affect: Set cellrange = Range("M8:M44").Cells.SpecialCells(xlCellTypeConstants) For Each cell In cellrange cell.Value =...
  2. jim may

    Modification of Code

    Allen Wyatt (on his site) has created the below Code and it works GREAT. Sub PageBreak() Dim CellRange As Range Dim TestCell As Range Set CellRange = Selection For Each TestCell In CellRange ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakNone If...
  3. N

    pull data from cclosed wb: formulaaray error

    Hi all, been struggling with this one and could use some help. Im trying to pull data from a closed workbook. I have a code that has worked for me in the past. All I have done is edit the path to accommodate for the new workbook, however I keep receiving an error. (1004 unable to set the...

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