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 » References change when executing macro
References change when executing macro
Resolved · Urgent Priority · Version 2007
Thu 17 Feb 2011, 11:50Delegate Frederic said...
Frederic has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
References change when executing macro
Hello,
I have a macro that draw a circle object in spreasheet "1" using coordinates found in spreadsheet "2". It draws on top of a picture. However, when executing the macro repeatively, the dots are shifted with each iteration and not always in the same way. Could you please help on this. This might be another question but could you also tell me how to fix the background picture so no one can change its position.
I thank you very much for this.
Regards,
Fred.
Thu 17 Feb 2011, 12:03Trainer Stephen said...
RE: references change when executing macro
Hi frederic
Thanks for your question
In order to answer this I would need a copy of the workbook with the macros in question
If possible could you email it to sw@stl-training.co.uk, and then I can take a look
Thanks
Stephen
Tue 22 Feb 2011, 11:44Delegate Frederic said...
RE: references change when executing macro
Hi Stephen,
I have now sent you a copy of the workbook for your perusal.
Your help would be much appreciated on this and I thank you for it.
Regards,
Fred.
Tue 31 May 2011, 15:20Trainer Stephen said...
RE: references change when executing macro
Hi Frederic
I apologise for the delay in getting back to you. This was due to an oversight on my part
I appreciate that you may now have resolved the problem. If not let me know and I will give it my urgent attention
Regards
Stephen
Wed 1 Jun 2011, 14:15Delegate Frederic said...
RE: references change when executing macro
Hello Stephen,
I have not yet been able to resolve this problem so your help would be welcome. let me know if you neeed further information. there was a second item to my original post that, again, have not found answer about so it would be good if you could give me a hint as well for this one.
Thank you very much.
Regards,
Fred L
Wed 8 Jun 2011, 10:20Trainer Stephen said...
RE: references change when executing macro
Hi Frederic
Thanks for that. I will look at the problem over the course of today and tomorrow. I cannot find the workbook that you originally sent me. I think I may have lost it when my old laptop died.
Could you resend it to sw@stl-training.co.uk
Thanks
Stephen
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:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
