View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmadden2 mmadden2 is offline
external usenet poster
 
Posts: 4
Default 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