ExcelBanter - View Single Post - getting the adress on the last row

Thread: getting the adress on the last row

View Single Post

#2

Report Post

Posted to microsoft.public.excel.programming

C. Roenbaugh C. Roenbaugh is offline

C. Roenbaugh is offline

external usenet poster

Posts: 16

Default

getting the adress on the last row

Try this

set myRange2 = Range(Range("a1"), Range("a1").End(xlDown))

With myRange2
i = .rows.count
j = .myRange2.cells(i,0).address
end with

Reply With Quote

Reply With Quote