I just have a question. Can I change in formula from below
ActiveCell.FormulaR1C1 = "=R[-1]C[-1]+RC[-1]+RC[-2]+RC[-3]"
into something like:
For i = 1 to n
"make summ from" cells(1,i)
Actually i would like to change the RC format in something where i can control a row or a column, no matter what formula i use
You can assign the row & column references to variables and then use it in the RC formula.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi IstrateCr,
You can also use built-in function of Excel - those builded functions should always work faster then self written
or even write your own function and then call it in any call of your workbook ["=countIT(A1:A3)"]
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by MaczaQ; 02-02-2012 at 02:24 PM. Reason: code clean up
Best Regards
MaczaQ
---------------------------------------------------------------------------------------------------------------------------
If you are satisfied with the solution(s) provided, please mark your thread as Solved
If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
- This way you will add him some reputation points ... thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks