Copy from named range down until lastrow?

**jazbath** · 01-19-2007, 02:55 PM

Hi,
I have a named range in my worksheet. Now from that range (In col A) I like to select down until lastrow (which I have already dimmed as lastRow as object) and copy. How can I do that in code. Please help.
thank you
Jaz

**mrice** · 01-19-2007, 03:38 PM

Try this as an example

Sub Test()
Dim LastRow As Object
Set LastRow = Cells(24, 1)
Range(Cells(Range("MyRangeName").Row, 1), Cells(LastRow.Row, 1)).Copy
End Sub

**jazbath** · 01-19-2007, 05:56 PM

Thank you Mrice.
Jaz

Copy from named range down until lastrow?

LinkBack

Thread Tools

Rate This Thread

Display

Copy from named range down until lastrow?

Response

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions