Cant get to fill using plus handle to fill serial number-WHY

[CAPTGNVR]

DEAR ALL

Two cells are highlighted with a1 =1 and a2=2. I see the plus handle and I
drag it to a50. Instead of putting the serial number - all cells a1 to a50
shows value 1.

using Excel 97.

Pls note that only in this worksheet I do not get that edit-fill "series"
option and feel this is the reason for cells a1 to a50 becoming value1. but
other worksheets are ok and the "series" option does get highlighted and
putting serial numbers no problem.

So what could be done to highlight the 'series' option or can u sugest some
VB??

 

[Dick Kusleika]

DEAR ALL

Two cells are highlighted with a1 =1 and a2=2. I see the plus handle and I
drag it to a50. Instead of putting the serial number - all cells a1 to a50
shows value 1.

using Excel 97.

Pls note that only in this worksheet I do not get that edit-fill "series"
option and feel this is the reason for cells a1 to a50 becoming value1. but
other worksheets are ok and the "series" option does get highlighted and
putting serial numbers no problem.

So what could be done to highlight the 'series' option or can u sugest some
VB??

CAPTGNVR: It's nice to post the solution in the original thread for when
people search on it later, so I'm posting it here.

CAPTGNVR said:

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

 

[CAPTGNVR]

D/DICK KUSLEIKA

I will be guided by what u sugested in future to post in original thread and
I also appreciate the pains u took to post the solution in the correct thread
and for being so considerate.

wrgds/captgnvr