Find the last row in a row and then have the information go down to the next row

**BigCrain05** · 08-12-2011, 09:10 PM

Hi guys, Im kinda new to execel, but i know a little bit. Now i have a copy and paste macro, now what i want it to do is after it paste in the correct row after it does it once i want to be able to have it copy it to the row under it. And to do that until there is no more lines on the excel. Please any help will be appreciated.

This is what i have so far:

Please Login or Register  to view this content.

**davesexcel** · 08-12-2011, 09:25 PM

Please Login or Register  to view this content.

http://www.davesexcel.com/rangeselectioncodes.htm

**BigCrain05** · 08-17-2011, 08:25 AM

Ok thanks dave but im a little slow when i copied and pasted that into the VBA, I go an error and im a little confused on how to get it work what would i need to plug into that to get it to work. and also would i need to delete the coding i already have or would i just need to start a new sub? Thank you for your help

**davesexcel** · 08-17-2011, 07:27 PM

Try this:

Please Login or Register  to view this content.

**BigCrain05** · 08-18-2011, 09:35 AM

Dude you rock. I have been working on this for months now and you fixed it in like 2 days. THANK YOU SO MUCH

Find the last row in a row and then have the information go down to the next row

LinkBack

Thread Tools

Rate This Thread

Display

Find the last row in a row and then have the information go down to the next row

Re: Find the last row in a row and then have the information go down to the next row

Re: Find the last row in a row and then have the information go down to the next row

Re: Find the last row in a row and then have the information go down to the next row

Re: Find the last row in a row and then have the information go down to the next row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions