 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Row_Calculation
I have a for a formula in a macro: ActiveCell.FormulaR1C1 = _ "=MID(R[-11]C,FIND("","",R[-11]C,1)+2,10) & "" "" & MID(R[-11]C,FIND(""D_"",R[-11]C,1)+2,FIND("","",R[-11]C,1)-FIND(""D_"",R[-11]C,1)-2)" I need to replace the "-11" with a variable name that I calculate prior to this. Can I do this? If so, I need your help. I still trying to understand macros. thanks for looking. El Bee. You could do this: Var = -11 ActiveCell.FormulaR1C1 = _ "=MID(R[-" & Var & "]C,FIND("","",R[-" & Var & "]C,1)+2,10) & "" "" & MID(R[-" & Var & "]C,FIND(""D_"",R[-" & Var & "]C,1)+2,FIND("","",R[-" & Var & "]C,1)-FIND(""D_"",R[-" & Var & "]C,1)-2)"  SignatureAdilson Soledade > I have a for a formula in a macro: > ActiveCell.FormulaR1C1 = _ [quoted text clipped - 11 lines] > > El Bee. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.