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??

On Fri, 21 Mar 2008 09:25:01 -0700, CAPTGNVR
<(E-Mail Removed)> wrote:

>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
--
Dick

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

"Dick Kusleika" wrote:

> On Fri, 21 Mar 2008 09:25:01 -0700, CAPTGNVR
> <(E-Mail Removed)> wrote:
>
> >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
> --
> Dick
>