copying nested if statements

L

loopy

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.

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

You help is much appreciated :
 
F

firefytr

hi loopy,

have you tried replacing your paste line in your code to
pastespecial, maybe something related to this...

Range("A1").PasteSpecial xlPasteFormulas

unless you cared to post your code. if that be the case i suggest yo
post it in the excel programming forum. you'd probably get much bette
and faster results.

ht
 
L

loopy

thank for the tip, but.....
paste special still leaves in the links!!


I will try the programming forum - thank
 
Top