Forum home » Delegate support and help forum » Microsoft VBA Training and help » VBA

Active questions (69)
Advanced/consultancy questions (6)
Today's questions
Unanswered questions (13)

VBA

The UK's most regular instructor-led training courses.
Training information: access visual basic courses · Excel london

Resolved · Urgent Priority · Version 2003

4 posts

ReplyMon 13 Oct 2008, 15:25Delegate Edward said...

Edward has attended:
Excel VBA Intro Intermediate course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

VBA

I have a worksheet with multiple rows and columns

In each cell running down column A I have a macro button which when pressed should export just that line of data.

I have written the code to do what i want but when i try and apply the macro to the cells below it uses the same macro, and will export from the first row in the data base.

so basically i want the macro in A2 to cut and paste b2,c2,d2 etc. and the macro in A3 to cut and paste B3,c3,d3 etc.

How do i copy the macro down across say 100 lines and get it it to cut and paste just the info on that line, because at the moment i would have to write 100 macros.

Many Thanks for any help you are able to offer

Kind Regards

Ed

825 posts

ReplyMon 13 Oct 2008, 16:49Trainer Stephen said...

RE: VBA

Hi Ed

Thank you for your question

It is difficult to advise you directly without seeing your spreadsheet. If possible, could you email me a copy of the workbook, and I will give it my urgent attention.

My email is stephenATmicrosofttraining.net

Regards

Stephen

255 posts

ReplyWed 15 Oct 2008, 10:00Trainer Jacob said...

RE: VBA

Hi Ed

Stephen has updated me on your request, he has had a look at the workbook you forwarded, thanks for this, and we have established that it will take at least 1/2 day to work and resolve.

This sort of work is consultancy and if you wish to know more on how we can assist please let me know.

Regards

Jacob

4 posts

ReplyWed 15 Oct 2008, 12:18Delegate Edward said...

RE: VBA

i am interested in hearing about how best to resolve my query, please contact me to discuss consultancy rates on 07879403987

Kind Regards

Ed

· Company Roles in Visual Basic Training
· Microsoft Excel, Tailor-Made For Your Business Thanks To VBA
· VBA - Not Just For Programmers
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Computer Programming Made Easy With VBA

Please browse our web site to find out more about
access visual basic courses and other Microsoft training courses.

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

VBA

VBA

RE: VBA

RE: VBA

RE: VBA

Related articles

Vba tip:

Suspend DisplayAlerts in VBA