The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA

Resolved · Urgent Priority · Version 2003

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

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

For upcoming training course dates see: Pricing & availability

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

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

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

VBA articles

· VBA - What Is It, And Should You Learn It?
· How To Use VBA To Create A Data Entry Box In Excel
· An Introduction To The Excel VBA Editor Screen
· VBA For Beginners - Only A Script Away From Endless Possibilities...
· VBA With Excel - Making The Working Day That Little Bit Easier

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

Vba tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips

In excel 2003 I could have similar data in several sheets (account number, name, amount owed etc) sort it in the first sheet then go to the next sheet and do edit repeat sort. I can't find how I do this in excel 2007.