SortOn:=SortOnCellColor - Named argument not found

[Emeng]

Hi all

I have copied & adapted the text of the macro recorder to sort by colour but receive the above error.

The code blows out on SortOn which is the last line of the procedure... so far.

Range("MyRange").Sort Key1:=Range("D" & newRow), SortOn:=xlSortOnCellColor, Order:=xlAscending, DataOption:=xlSortNormal

See attached file.

Any help is much appreciated

Thanks & regards

Mark

 

[vletm]

Emeng
Hint:
You should record again,
You needed macro and
check - what is there.
After that,
use needed parts of it.
eg:
Where is 'clear'?
You've set MyRange variable as selection ... but later You are using "MyRange" ... hmm?
... and so on.

 

[Emeng]

Took your advice and all OK.
Thanks.