View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Lund Tim Lund is offline
external usenet poster
 
Posts: 1
Default .CurrentRegion in Excel functions

I have some code in a function that includes a line

set r = r.currentregion

But it doesn't work - r remains r, even when there are
contiguous cells to it. Any ideas why?

Tim Lund