COPYING FORMULA EXAMPLE FROM HELP (UNKNOWN BOX) HOW TO DELETE?

N

Need2Noe

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
 
S

Sheeloo

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

Gord Dibben

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 F5>Special>Objects>OK

Edit>Delete


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
problems getting this macro to work 23
Copy data from once worksheet to another using formula 2
Copy a Formula in a Macro 3
Lost functionality to copy a formula across rows 1
Autopublishing creates a bitmap of charts and text boxes 3
New workbook and darn text boxes 3
COPY EXCEL 2007 9

Top