ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   combobox code (https://www.excelbanter.com/excel-discussion-misc-queries/251500-combobox-code.html)

[email protected] uk

combobox code
 
i can't get the following listfillrange code to work more than once
='g:\[data.xlsx]sht'!a1:c66.

after the excel file is saved and closed the listfillrange changes to
[data.xlsx]sht'!a1:c66.

what is causing this to happen


All times are GMT +1. The time now is 01:47 PM.

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