LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Copy of sheet contains the named 'Control'. Action required.

Hi to all

I have a macro that copies a sheet and although it was working well, one day
I suddenly got the message:

A formula or sheet you want to move or copy contains the name
'HTML_Control', which already exists on the destination worksheet. Do want
to use this version of the name?
To use the name . . . . etc


If you click on 'Yes' it continues an if 'No' you can't continue although it
doesn't actually 'bomb'.

Although it still works, the user gets very confused each time it happens
(each month).

What causes it and how can I find the named 'Control' and eliminate it?
I have searched for 'HTML_Control' without success.

Thanks
Peter Bircher


 
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
Excell copy action pauses for 15 second for the smallest action Meekal Excel Discussion (Misc queries) 1 January 28th 10 04:30 PM
Excel 2002 SP3 Copy Worksheet with another sheet named range now # Brewmanz Excel Discussion (Misc queries) 0 October 1st 09 12:35 AM
Copy data and paste to different sheet named on Group Prem Excel Discussion (Misc queries) 1 February 21st 08 02:56 PM
Planilha action control Renato New Users to Excel 0 December 8th 07 06:34 PM
Copy Sheet action very slow RobN[_3_] Excel Discussion (Misc queries) 0 June 27th 07 03:32 AM


All times are GMT +1. The time now is 06:11 PM.

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

About Us

"It's about Microsoft Excel"