Macro that copy and pastes last used row under last used row

This is my macro so far. It copies and pastes the last used row under the last used row. I just want it to copy and paste A-I which messes up when I try to input it.

Please Login or Register  to view this content.

Thanks

Hi paytoplay, welcome! This procedure finds the last used cell in column A, copies columns A:I of that row, and pastes them on the next row down.:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

'All defined cell ranges are assumed to be on the ACTIVE worksheet unless
'some other sheet is specified, so let's activate the one we're working on.

Please Login or Register  to view this content.

'Starting at the very bottom of column A, search up until you find a NON-BLANK cell.
'This is equivalent to selecting cell A10488576 and pressing CTRL + UP_ARROW.
'Once you've got the right single-cell range, expand it to include 1 row x 9 columns.

'The With statement lets us temporarily use methods and properties on a specified OBJECT
' - in this case our 9-cell range - without having to fully "qualify" it every time. Simply
'precede the method or property with a period ("."); VBA will know which object they apply to.

Please Login or Register  to view this content.

'We're applying the Range.Copy and Range.Offset methods to the last row of data. The Range.Copy
'method has an option to do "simple" copy/pastes in one operation by specifying the destination.
'(If you need more control over the process, use a separate Range.PasteSpecial statement.) We
'want to paste in the next row down. The Range.Offset method is perfect for this; it let's us
'designate row- and column-offsets to define a new range of the same size as this one.

Please Login or Register  to view this content.

'We're done working with this object, so terminate the With "block". With statements can make
'your code shorter AND faster, but tread carefully. A missing period is difficult to spot, but
'can cause your procedures to crash or behave strangely. Many a bug has been born thusly.

Please Login or Register  to view this content.

'Turn off the "Marching Ants" (animated copy border) and return to standard ready mode.

Please Login or Register  to view this content.

@paytoplay

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

You're welcome, thank you for the rep! When it comes to coding, it's all about moving in a known direction through trial and error. Don't be afraid to fail, and don't hesitate to ask for help when you're truly stuck.