View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default how to return a range

I need to return a range to send it to a function. This is what I am using

Set ranger = Range(Cells(TRow, 14), Cells(TRow, TCol + 3)).Address

It doesn't seem to work. All the variables are correct in debugger but the
ranger (dim as range) is "nothing".

Thanks again