Macro to select cells at end of range of data

[johnlynches]

I currently have the following code in my macro:

Please Login or Register  to view this content.

It copies multiple rows of data, anywhere from 2 rows to 50+. What I am trying to do is get the below code one to take this action one row below the bottom of the range of data that has been pasted onto the sheet "Target".

Please Login or Register  to view this content.

The F9 and F10 cells would be relative to the bottom of the range of data being on row 7. I am not sure how to make this relative to the range pasted from the first code. So if the bottom of the rang of data was row 12, the Range("F9").Select would change to Range("F14").Select

[Leith Ross]

Hello johnlynches,

Here is one way to accomplish the task. In VBA it seldom necessary to select an object before an action is performed on it.

Please Login or Register  to view this content.

[Alf]

Hi Johny

I've changed the macro a bit. See if this is what you need for getting the pdf files.

On sheet "Transformed" there is a border around cell N3, don't delete that as I copy this to get borders around the other cells on sheet "Target"

Still I think you need to upload a csv file, it's much better in my opinion to import the csv files directly in excel 2007and get the proper layout at once.

Alf