The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying data

	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

Copying data

Resolved · High Priority · Version 2007

ReplyTue 9 Feb 2010, 11:49Delegate Lee said...

Copying data

What is the code for copying data from a cell down to the point where the data in the cell to the left stops.

I have data in cells C12 to C50 I need to write a code to copy the formula i have in cell D12 to D50
The number of rows that has the data will change every time i run the macro so i need to copy the data down as far as required.(i.e not down to row 50 every time)

Thanks
Lee

For upcoming training course dates see: Pricing & availability

ReplyFri 12 Feb 2010, 16:31Trainer Stephen said...

RE: Copying data

Hi Lee

Thanks for the question

I would create an uinteger variable and set it equal to the rows count of the current region of the first cell in the column.

introws = range("A1").currentregion.rows.count

you could then use a For loop to start at row one and go to the final row as determined above. At each point in the loop you could write in the formula

Regards

Stephen

Excel articles

· Microsoft Excel Training Course
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· Update Your VAT Rates In Excel
· Some Interesting Finds In Excel 2007/2010 Using Find And Select
· Conditional Formatting: A Useful Feature Of Excel

Please browse our web site to find out more about
exce+training and other Microsoft training courses.

Excel tip:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips

Is it possible to do an elbow connector with rounded edges, and the curved connector looks clumsy for the purpose I need it.

Thanks,
Norah.

» Forum post: Connectors

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions