| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
coppying nested if statements
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF statements | Excel Discussion (Misc queries) | |||
| Nested If Statements | Excel Worksheet Functions | |||
| Nested IF statements | New Users to Excel | |||
| Nested if statements - is there a better way? | Excel Worksheet Functions | |||
| Nested IF Statements | Excel Discussion (Misc queries) | |||
Linear Mode
