Hi,
Do you have controls on the worksheet? If so try renaimng
them to something other than commandbutton1. Do you select
all cells when copying or do you right click the sheet tab
then "make copy" ?
- -Mark
-----Original Message-----
I have a problem with one of my macros where I am copy an
entire worksheet
(not by range) to another workbook.
However, every other worksheet it seems comes across with
an message
indicating that that range name HTML_Control already
exists.
I had run a piece of code in my worksheet to outline all
range names and it
appears to be some kind of range name....and to my
surprise there are a whole
bunch of other names as well.
Can someone tell me if there is any specific purpose for
it?
.
|