coppying nested if statements

  • Thread starter Thread starter loopy
  • Start date Start date
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 :
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying nested if statements 2
A simple if <> nn then Msgbox "No Match" 5
Should I be content with the time code takes? 2
Improving Nested Formula Calculation Efficiency 2
Select Case Code does not run... 10
How do I coppy a range from 1 sheet to another via IF statement 2
Nested If / And Statement with Conditional Formatting. 2
Exit For statement in nested For ... Next blocks 3

Back
Top