copying 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.

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

You help is much appreciated :
 
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
 
thank for the tip, but.....
paste special still leaves in the links!!


I will try the programming forum - 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

coppying nested if statements 2
Cannot copy worksheet to another file 2
nest macro in a formula 2
Copying linked sheet 2
Excel Copy & Paste Issue ?? 5
solving nested IF statements 13
copying data from master ti individual sheets 3
I can't copy and paste equations 0

Back
Top