Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 04, 02:35 AM
Steven Cheng
 
Posts: n/a
Default HTML_Control Range name

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?

  #2   Report Post  
Old December 5th 04, 11:02 PM
Mark
 
Posts: n/a
Default

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?
.

  #3   Report Post  
Old December 7th 04, 07:37 AM
Steven Cheng
 
Posts: n/a
Default

Mark;

Thanks. I will try it out. Yes, I do have some controls on them. I will
rename some of the controls from the defaults.

any yes, I am copying the entire worksheets using make copy.

Steven

"Mark" wrote:

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?
.


  #4   Report Post  
Old December 10th 04, 06:25 PM
climber720
 
Posts: n/a
Default

Steven,
I seem to be having the same problem as you. Did Mark's suggested
changes work?

Thanks,
Josh

  #5   Report Post  
Old December 10th 04, 10:12 PM
climber720
 
Posts: n/a
Default

Steven,
I seem to be having the same problem as you. Did Mark's suggested
changes work?

Thanks,
Josh



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 02:51 AM
Invalid Range Name JSTLB0605 Excel Discussion (Misc queries) 5 December 3rd 04 05:10 PM
Sub out of range Jeff Excel Discussion (Misc queries) 1 December 2nd 04 02:21 PM
Macro for Show/Hide Range Bill Excel Discussion (Misc queries) 3 December 1st 04 05:33 PM
Range in VBA Jeff Excel Discussion (Misc queries) 1 November 26th 04 03:54 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017