View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_133_] mudraker[_133_] is offline
external usenet poster
 
Posts: 1
Default xldown and xlright

Instead of using ("D23, Range D23
(xldown).Address).end

Why not try

Range("d23").CurrentRegion.Cop

--
Message posted from http://www.ExcelForum.com