| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set reference to other sheet?
How can I set a reference to a cell on "MySheet5" cell A:5 ?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set reference to other sheet?
Hi
dim rng as range set rng = worksheets("mysheet5").range("A5") msgbox rng.value -- Regards Frank Kabel Frankfurt, Germany "HotRod" schrieb im Newsbeitrag ... How can I set a reference to a cell on "MySheet5" cell A:5 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set reference to other sheet?
Hi HotRod;
You can use this: Sheets("MySheet5").Range("A1") = "HotRod" Thanks, Greg -----Original Message----- How can I set a reference to a cell on "MySheet5" cell A:5 ? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set reference to other sheet?
Sorry I asked this question in the wrong group. I was wondering how to add
an reference in excel, not in VBA. SORRY |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set reference to other sheet?
Hi
then what do you mean with 'add a referece'? Maybe ='my sheet5'!A5 -- Regards Frank Kabel Frankfurt, Germany "HotRod" schrieb im Newsbeitrag ... Sorry I asked this question in the wrong group. I was wondering how to add an reference in excel, not in VBA. SORRY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| multiple cell reference from sheet to sheet | Excel Worksheet Functions | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Linear Mode
