coppying 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. 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 :
 
L

loopy

thanks, problem solved

the code i used to cancel the links was falling over becasue th
resultant formula was too long to be accepted by excel!

i found it when funning the rulines 'by hand' only then did exce
error!

the solution was to cut the link change code, and replace it with
find.... and replace with "".


thank
 
Top