| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range syntax
How come this piece of code does not work?
Dim Headers As Range Set Headers = Range(Cells(ImNavigateRow - 1, 2), Cells(ImNavigateRow - 1, 2).End(xlToRight).Column) I get an: Method 'Range' of object '_worksheet' failed error. Can anyone correct this for me? Thanks The Doctor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with the syntax for using range name in a formula? | Excel Discussion (Misc queries) | |||
| VB Syntax to select a range | Excel Discussion (Misc queries) | |||
| Need help with creating a Range Name syntax | Setting up and Configuration of Excel | |||
| range and cells syntax | Excel Worksheet Functions | |||
| Syntax for Range Reference | Excel Programming | |||
Threaded Mode
