98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » exce+training - Problems copying between worksheets
exce+training - Problems copying between worksheets
Resolved · Low Priority · Version Standard
Tue 20 Nov 2007, 14:52Delegate James said...
James has attended:
Excel VBA Intro Intermediate course
Problems copying between worksheets
Hi, The code below was generated by excel while recording a macro. It also seems to match code provided on the VBA course.
1 Range("A1").Select
2 Range("E5").Copy
3 Sheets("HPD List").Select
4 Range("B3").Select
5 ActiveSheet.Paste
When it runs though it gives an error on line 4:
Run-time error '1004':
Application-defined or Object-defined error
I think it may be something to do with a sheet being selected or acttive but have tried different combinations of selecting or activating the sheet HPD list and cell B3 and nothing works.
Any ideas please.
Tue 20 Nov 2007, 15:28Delegate James said...
RE: Problems copying between worksheets
Ok, I've moved the code in to a module and it seems to work properly now.
Given my last 2 questions, is there a general rule about what must be coded within a module as opposed to being able to be coded under forms or sheets?
Thanks
Wed 16 Jan 2008, 10:56Trainer Carlos said...
RE: Problems copying between worksheets
Hi James
Sorry for the delay in answering this question.
Code entered under sheets or forms only become active when the sheet/form becomes active.
So as a rule, specially if the code is generic or needs to be used by more than one object it should always be entered in a module.
Code specific to a sheet/form, usually takes the form of event procedures eg controlling what the sheet/form does on Open, Close and all other events and also controlling any buttons and other objects embedded in it.
Regards
Carlos
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
