I have two nested if statements (7nests in each) in a worksheet that
need to copy to many other worksheets (some 2000!)

So... I set excel vb on record and did a copy & paste.

This works but the resultant paste has links to my origina
spreadsheet. even pastespecial (formulas) creasts links

I cannot succeed in automating the copy and paste routine AND loosin
the links to my original sheet.

You help is much appreciated :

--
Message posted from http://www.ExcelForum.com