Thread: Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
temp temp is offline
external usenet poster
  
Posts: 20
Default 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
Reply With QuoteReply With Quote