Forum Discussion

Qi Qian's avatar
Qi Qian
Copper Contributor
Jan 23, 2018

Marco error / keyboard shortcut disable

After updating to version 16.  all my marco get error below.

 

Run-time error '438' Object doesn't support this property or method

 

--- after I press the debug, the below line is highlighted.

.UseListObject = False

 

and the find/replace function doesn't work properly.

 

it replace entire workbook rather than the special range I selected.

 

I use to use combo key : shift+fn+command+ arrow right, it doesn't work now.

 

 

 

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Please see https://support.microsoft.com/en-us/help/175616/fix-error-438-object-doesn-t-support-this-property-or-method support article.

    It talks about this error and how to fix it.