Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default COPYING FORMULA EXAMPLE FROM HELP (UNKNOWN BOX) HOW TO DELETE?

An undeletabe "box" is placed in the worksheet at the end of the copied
example range out of "help on this function". What is this and how is it
removed from the worksheet?

Using Excel 2003





--
THX,
Need2Noe
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default COPYING FORMULA EXAMPLE FROM HELP (UNKNOWN BOX) HOW TO DELETE?

Can you click on it? Do you get a drop-down list of options if you click on
the trinange?

It may be a warning... if you choose an appropriate option then it should go
away.

If it does not work then can you send the file to me?

"Need2Noe" wrote:

An undeletabe "box" is placed in the worksheet at the end of the copied
example range out of "help on this function". What is this and how is it
removed from the worksheet?

Using Excel 2003





--
THX,
Need2Noe

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default COPYING FORMULA EXAMPLE FROM HELP (UNKNOWN BOX) HOW TO DELETE?

All examples you copy or from a particular Function?

I tried on a half dozen Functions and could not replicate the "box"

To get rid of it try F5SpecialObjectsOK

EditDelete


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 14:33:12 -0800, Need2Noe
wrote:

An undeletabe "box" is placed in the worksheet at the end of the copied
example range out of "help on this function". What is this and how is it
removed from the worksheet?

Using Excel 2003


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
How do I delete the refernce a formula when copying and pasting? Lora Excel Worksheet Functions 1 July 23rd 08 11:47 PM
Unknown formula - not in help CrazyEd Excel Worksheet Functions 1 October 25th 07 07:07 PM
Unknown Formula: R[-1]c/r[4]c[-6] Clare Excel Discussion (Misc queries) 2 April 3rd 07 09:45 PM
Unknown Formula Lucky_guy2000 Excel Discussion (Misc queries) 4 April 28th 06 04:22 PM
Formula to look for value in a row depending on unknown value? pcsski Excel Worksheet Functions 2 April 25th 06 08:25 PM


All times are GMT +1. The time now is 05:49 AM.

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"