Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cant get to fill using plus handle to fill serial number-WHY
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?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cant get to fill using plus handle to fill serial number-WHY
On Fri, 21 Mar 2008 09:25:01 -0700, CAPTGNVR
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cant get to fill using plus handle to fill serial number-WHY
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Handle | Excel Worksheet Functions | |||
Fill handle fill down alternative methods question | Excel Discussion (Misc queries) | |||
what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Fill-handle doesn't fill all the way down | Excel Discussion (Misc queries) |