LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I? Perform simplae Average on a indexed text location Perplexed in Portland Excel Discussion (Misc queries) 9 June 16th 09 01:47 AM
Can you use formulas to manipulate the fill color of a cell? kAustin79 Excel Programming 6 August 18th 07 04:48 AM
Formula to manipulate cell font crs Excel Programming 5 September 11th 06 04:13 PM
Can you perform Math functions with ActiveX Checkbox controls? ForTor69 Excel Worksheet Functions 1 May 18th 06 05:23 PM
I need to math manipulate figs over 10,000( in hrs & min format)? ATECH Excel Discussion (Misc queries) 2 January 27th 06 10:09 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"