| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define Object Variable
Hi All,
This seems to be a so simple problem, but i can't figure it out. Here is my code im using: Sub test() Dim r As Range r = ActiveCell.Address MsgBox r Exit Sub When i run that code, i get a Run-Time error '91': Object Variable or With variable block not set If i use: Set r = ActiveCell.Address instead of: r = ActiveCell.Address then i get Type Mismatch error. Can someone please help. Cheers. Albert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
| Application-Defined or Object Define error? Help please. | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
| Pivot Table - Object variable or with block variable not set? | Excel Programming | |||
Threaded Mode
