ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IN ONE PARTICULAR EXCEL97 FILE CANT SEE FILL-SERIES-OPTION (https://www.excelbanter.com/excel-discussion-misc-queries/128220-one-particular-excel97-file-cant-see-fill-series-option.html)

CAPTGNVR

IN ONE PARTICULAR EXCEL97 FILE CANT SEE FILL-SERIES-OPTION
 
DEAR ALL

In one particular excel97 sheet, the VB i wrote to fill serial
number using -FILL-SERIES. After a lengthy cross checking found the
cause to be that 'SERIES option in EDIT-FILL- is disabled. Even
after unprotecting also the -series- option does not get enabled. But
in a new worksheet or other excel97 files have I can see. Why this
phenomena?



All times are GMT +1. The time now is 08:50 AM.

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