ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COPYING FORMULA EXAMPLE FROM HELP (UNKNOWN BOX) HOW TO DELETE? (https://www.excelbanter.com/excel-discussion-misc-queries/219341-copying-formula-example-help-unknown-box-how-delete.html)

Need2Noe

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

Sheeloo[_3_]

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


Gord Dibben

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




All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com