coppying nested if statements
 

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

coppying nested if statements
 

Post some of the code you recorded...



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

coppying nested if statements
 

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

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