Paste link of "new" rows

[Prinel01]

On Sheet1, I do have info from A1 - A10.

I copy it, and paste link it on sheet2.

If I add new info in Sheet1 next time (I use a program which populate info auto on sheet1), but this time the info is from A1 - A15.

How do I make sure that ALL the info on sheet1 are selected, and not only up to A10.

It can happen that the next time info is on A1 - A100.

Surely I do not want to select "empty" cells?

 

[CDICKENS]

Try this...

Dim lastrow As Integer

lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

'then in your selection code...
Range("A1:A" & lastrow).Select

Chuck

 

[Prinel01]

Try this...

Dim lastrow As Integer

lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

'then in your selection code...
Range("A1:A" & lastrow).Select

Chuck

Chuck

Thanks for your reply...

Is there not a option whereby a normal Excel user can select the area with keystrokes (Alt Shift Down Arrow?) and paste link? I think to ask a user to do the above will not work.

Regards