View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default .cells not applicable to range

I've been fooling with this line of code for over an hour. For some
reason, VBA won't accept ".cells" as a property or method or event of
..range today. Getting a "method range of object worksheet failed"
error. Any ideas? VBA help doesn't even recognize "cells" at all, so no
help there. But it is in the Object Browser shown as being ok with a
range and a range being ok with a worksheet.

Set rCopy = wsExtFrom.Range(.Cells(lCopyRow, lExtrFromCol),
..Cells(lCopyRow, lExtrToCol))

I've tried it with and without the periods in front of "cells".

All of the variables show in the "list" of applicable variables. I'm
stumped, again.

Thanks in advance.