| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
manipulate / perform math on cell location a=a+1
hi all,
i have a formula that results in... variable 'NBCell' = $I$102 how can i change this value's column letter or row number? for example, how can i... change $I$102 into $A$102 (I turns into A) change $I$102 into $I$104 (102 + 2 = 104) change $I$102 into $A$104 (I turns into A and 102 + 2 = 104) thank you very much, marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
manipulate / perform math on cell location a=a+1
Your question is a little thin on exactly what you are up to but here is a
general answer... sub Test dim strAddress as string dim strAddressNew as string strAddress = $I$102 strAddressNew = cells(range(strAddress).row, "A").address msgbox strAddressNew strAddressNew = range(strAddress).offset(2, 0).address msgbox strAddressNew strAddressNew = cells(range(strAddress).row + 2, "A").address msgbox strAddressNew end sub -- HTH... Jim Thomlinson "mmadden2" wrote: hi all, i have a formula that results in... variable 'NBCell' = $I$102 how can i change this value's column letter or row number? for example, how can i... change $I$102 into $A$102 (I turns into A) change $I$102 into $I$104 (102 + 2 = 104) change $I$102 into $A$104 (I turns into A and 102 + 2 = 104) thank you very much, marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I? Perform simplae Average on a indexed text location | Excel Discussion (Misc queries) | |||
| Can you use formulas to manipulate the fill color of a cell? | Excel Programming | |||
| Formula to manipulate cell font | Excel Programming | |||
| Can you perform Math functions with ActiveX Checkbox controls? | Excel Worksheet Functions | |||
| I need to math manipulate figs over 10,000( in hrs & min format)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
