Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
to sum the quantity of only applicable for last 7 days from today | Excel Discussion (Misc queries) | |||
Find Applicable Formula, then Use It | Excel Worksheet Functions | |||
Splitting cells using formula; RIGHT/LEFT not applicable | Excel Worksheet Functions | |||
VBA Problem - How to collect and display text information from applicable cells. | Excel Programming | |||
How mk code applicable to any active workbook? | Excel Programming |