For last one year I posted at least 5 times to find out why that edit-fill
"series" is not highlighted in one particular work book and for code running
very slow.

I thank and appreciate Mr. Mark Ivey, who guided me with emails after
emails in solving this.

The fault was that
a) the command button 'set foucs on lcick' must be set to false and
b) if the data filters are 'on', then the edit-fill 'serires' option is
disabled.

This is to help others if they face similar problems.

with rgds/CAPTGNVR