Dear Don, can you share your workbook with Group.
On Tue, Oct 25, 2011 at 1:40 AM, Don <donf...@gmail.com> wrote: > I have a report that is run daily. Every day the end user answers > among other things, what was yesterdays weather. They answer by > selecting the appropriate picture and clicking it. My excel workbook > then uses VBA to copy the appropriate reference picture and pastes it > in to the daily report. > > For more than 4 years, everyday when the new picture is pasted excell > has automatically sequentially numbered the picture next in line. If > the last picture yesterday was 4,626 todays weather picture becomes > Picture 4627 as shown in the name box. This had worked for more than > 4 years. > > Now it has quit functioning and instead of making the picture a new > sequentially numbered name, it is retaining the name of the reference > picture. I only have 30 reference pictures so the names are repeating > quite often and this is becoming a problem. I need my old unique > names back and I do not know what has occurred to change how this is > handled. > > I did inadvertently open and modify the workbook in Excel 2010 and I > am afraid it may have overwritten some of the Objects or Properties > which changed how the pictures are handled. > > Can anyone please assist me in getting my excel back to assigning > sequential numbers? > > Don > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel