Need help with Visual Basic

[Daniellel]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am completely self-taught with VB and am still a beginner. I have recorded a massive piece of code (it is about 11 pages in word) and it is really slow (about 30 mins) to run the macro. I does have a formula that it pastes into 840 cells on 4 different tabs ("=INDEX(TO3!$C$1:$I$9999,MATCH($A9&$B9,TO3!$A$1:$A$9999&TO3!$B$1:$B$9999,0),COLUMNS(TO3!$C2:C2))" ) I have posted about this before asking if anyone can help me speed it up but nothing has helped a great deal. The only thing people have referred to that I have not tried is a 'Helper Cell' but I am unsure what this means or how to do it. <o></o>
<o></o>
What I am really asking is if there is anyone out there that would be kind enough to run his or her expert eyes over it for me and to maybe help out. <o></o>
<o></o>
Can you help???<o></o>
<o></o>
Many thanks in advance<o></o>
<o></o>
Danielle

 

[Daniellel]

It's showing free for 5GB, 9.99 for 25GB here. Make sure you select only 5GB storage.

Are you saying the word Free does not show on the link I provided earlier?

Correct, the option for 5GB is not there, only 25G and 50GB

 

[p45cal]

Explore these:?
http://filecargo.com/
http://www.savefile.com/
http://www.2shared.com/
http://www.mediafire.com/
http://www.filefactory.com/
http://www.filesavr.com/
http://www.filedropper.com/

 

[Daniellel]

Explore these:?
http://filecargo.com/
http://www.savefile.com/
http://www.2shared.com/
http://www.mediafire.com/
http://www.filefactory.com/
http://www.filesavr.com/
http://www.filedropper.com/

I have used 'save file' and this is the link...

http://www.savefile.com/dl/HN3P9E2A


Thank you so much in advance, i really appreciate your help!

 

[Daniellel]

I have used 'save file' and this is the link...

http://www.savefile.com/dl/HN3P9E2A


Thank you so much in advance, i really appreciate your help!

I dont think that worked??? Try this...

http://www.savefile.com/dl/WBRT9XE7

 

[Daniellel]

everyone who goes to help me then goes offline

Is there anyone online and able to help me with this???

 

[p45cal]

20 minutes ago and now:
"Savefile is currently down for maintenance, we will be back shortly.
Estimated downtime: 10 minutes"

 

[Daniellel]

20 minutes ago and now:
"Savefile is currently down for maintenance, we will be back shortly.
Estimated downtime: 10 minutes"

Sorry,

Try this one???

http://www.2shared.com/document/Pnwv-uFp/Test_Merge.html

 

[p45cal]

I ran the macro, out of the box, so to speak, and it completed in less than 10 seconds - you say 30 minutes!!

What machine are you using? operating system?, version of excel? etc.
What other apps. are loaded?
If you tried running it with only Excel loaded (and only loaded with that file) - does it run faster?

It seems pointless me spending time speeding up code if the slow running is because of something else.

 

[Daniellel]

I ran the macro, out of the box, so to speak, and it completed in less than 10 seconds - you say 30 minutes!!

What machine are you using? operating system?, version of excel? etc.
What other apps. are loaded?
If you tried running it with only Excel loaded (and only loaded with that file) - does it run faster?

It seems pointless me spending time speeding up code if the slow running is because of something else.

Hi, Thank you for looking at this for me. I am using a HP Compaq PC (My work PC) and we only have excel 2003. Cant believe it only took 10 seconds! so jelous! i have to do this 3 times a day and it freezes my PC and does take up to 30 mins to come alive again! Really sorry if i have wasted your time, i had no idea that it might not be the VBA code. I have tried with only that document open and it does reduce it to about 20 mins but still not seconds

Thank you again

 

[p45cal]

I have no time left today - will look at streamlning the code tomorrow (UK time here).