Forum Discussion

hrh_dash's avatar
hrh_dash
Iron Contributor
Aug 07, 2022
Solved

Pop up error: run time error 438 object doesn't support this property or method

Pop up error: "run time error 438 object doesn't support this property or method" when finding the first row and the last row containing specific text as for in this case would be "DC2".   I would ...
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Aug 07, 2022

    hrh_dash 

    You should use lines such as

     

    ws.Range("H" & miscstartRow & ":H" & misclastRow).Copy

Resources