Find Last Row, Paste Data Last Row Plus two Rows

**sherylt13** · 08-07-2019, 09:36 PM

Hello, a quick last data row type question. Looking for assistance to find the last row of data to help pinpoint where I will then paste a "key" that will be located two rows after the last row of data, in column B.

In the attached, I have a "key" that needs to be pasted to the bottom of a (dynamic) list, two rows after the list ends, in column B. What is the best way to find the last row, add two, then copy/paste the key (from the second tab) at the bottom of the list?

Thanks again for any assistance,
Sheryl

**jindon** · 08-07-2019, 09:46 PM

Please Login or Register  to view this content.

**MarvinP** · 08-07-2019, 09:49 PM

Hi Sherylt,

The vba code to find the bottom row looks like this:

Dim LastRow as Double
LastRow = Cells(Rows.Count,"A").End(xlUp).Row

The Rows.Count is a number of the last row in your worksheet. Older Excel didn't have as many rows as newer Excel does. The Cells(Rows.Count,"A") moves the cursor to the bottom of column A. Then the End(xlUp) is like pressing Ctrl + Up on the keyboard. It jumps to the last entered anything in Col A. The .Row gives you the row that is the last one in your column A. If you add 2 to that, you will get the number you seek.

Or read: https://www.excelcampus.com/vba/find...w-column-cell/

Hope that helps.

**sherylt13** · 08-08-2019, 08:48 AM

Thank you !!

**sherylt13** · 08-08-2019, 08:49 AM

Thank you for the added information, very helpful.

Sheryl

Find Last Row, Paste Data Last Row Plus two Rows

LinkBack

Thread Tools

Rate This Thread

Display

Find Last Row, Paste Data Last Row Plus two Rows

Re: Find Last Row, Paste Data Last Row Plus two Rows

Re: Find Last Row, Paste Data Last Row Plus two Rows

Re: Find Last Row, Paste Data Last Row Plus two Rows

Re: Find Last Row, Paste Data Last Row Plus two Rows

Thread Information

Users Browsing this Thread

Similar Threads

Loop through column to find EID then find date and paste corresponding data

[SOLVED] Macro to use cell value in ws1 to find same value in ws2 then add rows and paste.

Find a cellvalue, add rows, get data, paste data and copy data from original row

How can I find all rows w/ similar names then cut & paste them together?

Speeding up Find Cut/Paste Rows

Find and paste rows into new workbook

[SOLVED] Macro to: Find a Reference, and then Paste into the 10 Rows Below

Bookmarks

Bookmarks

Posting Permissions