RUNT_TIME Error - Applying AutoFilter to column that has results of formula using VBA

HI VBA Experts…

I have the following:-
Worksheet called “COUNTRIES” and in cell M1 = “CODE_Group”, M2 = 99
Define Name = CODE_Group and the formula used is ‘=COUNTRIES!$M$1’
Define Name = GroupData and the formula used is ‘=OFFSET(CODE_Group,1,0,COUNTA(COUNTRIES!$M:$M)-1,1)’

My data worksheet is called “Data_PasteArea” with various data in Columns A:O and column O has formula based calculations resulting in 9, 99 OR blanks. I want to apply AutoFilter and select all rows that match with 99 (indicated above - M2 = 99) using VBA code.

My VBA code is giving - Run-Time error ‘-2147417848 (80010108)’:
Method ‘AutoFilter’ of object ‘Range’failed

VBA code is as follows -

Please Login or Register  to view this content.

Please could you help to correct where I am going wrong.
Thx
Dhiresh