GET-IT: TEAMS DAY | 1-Day Free Virtual Conference all about Teams. Here on Petri.com - 8/12/20 GET-IT: TEAMS DAY - 8/12/20

Unable to get the SpecialCells property of the Range class error

Home Forums Scripting General Scripting Unable to get the SpecialCells property of the Range class error

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    ekrengel
    Member
    #121657

    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
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.