Thread: getting the adress on the last row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alvin Kuiper alvin Kuiper is offline
external usenet poster
  
Posts: 175
Default getting the adress on the last row
Hi
can i with
Set myRange2 = Range(Range("a1"), Range("a1").End(xlDown))

Get the last rows adress
like if the last post i have is in A11 then
get the adress A11

Reagrds
Alvin

Reply With QuoteReply With Quote