Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 Greets All, I'm looking for a formula of VB script in excel to calculate between reference style and formula style tia sal2 Example If A1:Q18 is typed in I would like R1C1:R18C17 to show up or vise a versa in another cell...can this be done? Also can I add rows and coumns togather. Example can I do this R1C1 + R2C3 = R3C4 or A1 + B2 = C3 Tia sal2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Reference Style | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Worksheet Functions | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions |