| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Kind of like offset.....
Say I have the following variables
myVar1 = 1 myVar2 = Sheet("sheet1").Range("B5") how do I get myVar2 to equal Sheet("sheet1").Range("C5") using myVar1 also; how do I get myVar2 to equal Sheet("sheet1").Range("B6") using myVar1 Bruce |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Kind of like offset.....
Hi
try: myVar2=Sheet("sheet1").Range("B5").offset(0,myvar1 ).value and myVar2=Sheet("sheet1").Range("B5").offset(myvar1,0 ).value -- Regards Frank Kabel Frankfurt, Germany Bruce wrote: Say I have the following variables myVar1 = 1 myVar2 = Sheet("sheet1").Range("B5") how do I get myVar2 to equal Sheet("sheet1").Range("C5") using myVar1 also; how do I get myVar2 to equal Sheet("sheet1").Range("B6") using myVar1 Bruce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different kind of rounding | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| How to do for this kind of formula? | Excel Discussion (Misc queries) | |||
| What kind of Formula?? | Excel Discussion (Misc queries) | |||
| Different Kind of Progress Bar... | Excel Programming | |||
Linear Mode
