Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application defined or object defined error
Code doesn't run:
Set r = activesheet.Range("F2") Set rR = activesheet.Cells(r, r.End(xlDown)) <----- APPLICATION DEFINED OR OBJECT DEFINED ERROR rR.NumberFormat = "mm/dd/yy" I tried putting in .range after activesheet, but that doesn't help either. Any suggestions? Thanks again. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
application defined or object defined error
I don't see a problem with it. I ran it just fine. Are you sure you defined
both r and rR as Range? What are you trying to do with this? Also, I think you have your row/column mixed up in your second line. With Cells() row comes first then column so maybe: Set rR = activesheet.Cells(r.end(xldown), r) ?? What are you after here? "davegb" wrote: Code doesn't run: Set r = activesheet.Range("F2") Set rR = activesheet.Cells(r, r.End(xlDown)) <----- APPLICATION DEFINED OR OBJECT DEFINED ERROR rR.NumberFormat = "mm/dd/yy" I tried putting in .range after activesheet, but that doesn't help either. Any suggestions? Thanks again. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
application defined or object defined error
Set rR = ActiveSheet.Range(r, r.End(xlDown))
davegb wrote: Code doesn't run: Set r = activesheet.Range("F2") Set rR = activesheet.Cells(r, r.End(xlDown)) <----- APPLICATION DEFINED OR OBJECT DEFINED ERROR rR.NumberFormat = "mm/dd/yy" I tried putting in .range after activesheet, but that doesn't help either. Any suggestions? Thanks again. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming |