Announcement

Collapse
No announcement yet.

Unable to get the SpecialCells property of the Range class error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to get the SpecialCells property of the Range class error

    I am getting a "Unable to get the SpecialCells property of the Range class" error when trying to run my script.

    Is this right?

    Code:
    objExcel.Range("B:B").Select
    objExcel.Selection.Specialcells(xlCellTypeBlanks).Entirerow.Delete

  • #2
    Re: Unable to get the SpecialCells property of the Range class error

    Once again I have answered my own question and found it somewhere else:

    objExcel.Range("B:B").Select
    objExcel.Selection.Specialcells(4).Entirerow.Delet e' 4 = xlCellTypeBlanks

    Comment

    Working...
    X