We have a spreadsheet with a macro to send a copy of the spreadsheet as an email attachment. For some people the macro runs perfectly but for a couple it appears to stop completely. Further tests showed that the macro does carry on if you're patient enough to wait about 60 seconds. From the last two behaviours I'm actually doubting that this is a scripting/coding issue but still I thought I'd sound out the issue here as well as in the Office forum.
The point at which it stalls is here:
All that is is the equivalent of 'Edit...' -> 'Paste Special' -> 'Values'.
The reason I don't think this is a coding issue is because this issue only happens to two people but not at all to other users of the same spreadsheet. Also, I got one of the people who does this issue to log on to another PC to find the problem doesn't occur there.
So, I did an Office (2003) repair on his PC but this did not clear the issue.
Does anyone have any idea what could cause this apparently simple function to pause so?
JJ
[small][purple]Variables won't. Constants aren't[/purple][/small]
The point at which it stalls is here:
Code:
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=FalseAll that is is the equivalent of 'Edit...' -> 'Paste Special' -> 'Values'.
The reason I don't think this is a coding issue is because this issue only happens to two people but not at all to other users of the same spreadsheet. Also, I got one of the people who does this issue to log on to another PC to find the problem doesn't occur there.
So, I did an Office (2003) repair on his PC but this did not clear the issue.
Does anyone have any idea what could cause this apparently simple function to pause so?
JJ
[small][purple]Variables won't. Constants aren't[/purple][/small]
