Below is the copy/paste code discussed earlier that works faultlessly.
It is Module4 of a four Module Excel spreadsheet. However, when I run the
'Sub Marco' (this one), it freezes the main macro that gathers data from
the web (which is where the sub macro gathers the copy data).

Can I run several macros simultaneously? I probably need to break
everything down and start afresh?

Should I incorporate this code into one of the other modules and run the
main macro. The code is lengthly, so I cannot post it here.

Thanks.


Sub The_Sub()
Sheets("Show").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Chartdata").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.Wait (Now + TimeValue("0:00:30"))

Sheets("Show").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Chartdata").Select
Range("C2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.Wait (Now + TimeValue("0:00:30"))......(and so on)....
End_Sub