Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am having a problem with declaring a range object. The code which I receive the Application/Object Defined error for is Set myRange2 = ThisWorkbook.Worksheets("Procedures").Range(Cells( TotalNames + 3, 1), Cells(TotalNames + 3, 2)) I am frustrated because I have a line of code in my program which does work and is almost identical. Set myRange = ThisWorkbook.Worksheets("Procedures").Range(Cells( 2, NumberofBuilds + 2), Cells(3, NumberofBuilds + 2)) I am unclear of how to use Range syntax, but I am comfortable referring to cells using cell index numbers. Any help or reccomendations would be appreciated. Thanks for your time. Dylan H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
Application-defined or object-defined error - missing the basics | Excel Programming |