| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN'T reference Value on another sheet!
Thanks , that worked
This one I also picked up on another post For Each c In Range("Currencies") If c.Value = cur Then AD = Range(c.Offset(0, 3), c.Offset(0, 3)).Value Exit For End If Next c This way you keep on referencing c wich has scope on the sheet of the range that it is busy looping through (or something like that) Thanks again R |
| 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) | |||
Threaded Mode
