| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named range in a sheet referred to from another sheet
(Using Excel 2000 under Windows 98)
I have created a 1-cell named range by selecting cell A1 on Sheet1 and then typing the name "MyCell" (without the quotes) in the names Litsbox. Thereafter, I have typed this code in the click event of a command button located in another sheet (Sheet2): Range(ThisWorkbook.Names("MyName")).Value = 100 When I click on the button I get error 1004. However, if the button is in Sheet1 it works fine. So how do I have to MyCell in the first case? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named range on another sheet | Excel Worksheet Functions | |||
| Macro to insert named range in each sheet | Excel Programming | |||
| Recalculate Named Range After Sheet Changes | Excel Programming | |||
| Loop thru named range of second sheet | Excel Programming | |||
| Referencing Named Range in Other Sheet | Excel Programming | |||
Threaded Mode
