ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   For last one year trying to find out- pls help (https://www.excelbanter.com/excel-programming/408027-last-one-year-trying-find-out-pls-help.html)

CAPTGNVR[_2_]

For last one year trying to find out- pls help
 
Excel 97: In one of the workbook, in the -edit-fill- the 'series' option is
not highlighted but in rest of the workbooks the 'series' option is
highlighted.

Unfortunately, that sheet has lots of places where I have to use serial
numbers and without that option -series- I am unable to fill the numbers
--like if the last number is 300, i am unable to go to a299 and mark till
a300 and drag the plus sign to fill till 400.

Trust me, posted this many times and never get assistance. Pls tell me what
could be the reason for not having this option in just one workbook. For
your information the sheet is not protected.

Can anyone suggest how to activate it using VB as even after resetting the
tool bars still I dont get to see the -series- option highlighted.


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com