Hi all,
Am trying to write a formula to certain cells but for some reason this ain't working.
Formula is:Yes, I know it's a "bit" long one but I don't know any other way to do this....
Please Login or Register to view this content.
Edit: Code-tags added
Last edited by torppo; 02-06-2014 at 02:49 AM.
could you upload a sample excel file?
Click on the star if you think I helped you
Hi, torppo,
you would need to add code-tags to your formula code as requested in Forum Rule #3 first to allow us to answer to your question.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Attached is an example of my file.
Hi, torppo,
thanks for adding the code-tags.
Your formula is to be put in in R1C1 notation so all references should be in that notification as well like
If you usePlease Login or Register to view this content.
this is A1 notification and you would need to decide which of the two ways of notifications you want to use, convert them accordingly and then either stay with FormulaR1C1 (for R1C1) or use Formula (for A1) in order to write the formula.Please Login or Register to view this content.
HTH,
Holger
Hi HaHoBe,
And thank you for your reply.
I made changes you suggested but still no cigar. Could the problem be now with (RC[0])???
New code:
Please Login or Register to view this content.
Hi again,
Let's try this again. Below is the original Excel formula which need to be written with VBA:
Is this possible or would it be possible to do same thing with Array??Please Login or Register to view this content.
Thank you in advance!
I think I got it, though it's not in R1C1 format
Please Login or Register to view this content.
Last edited by djdjdj; 02-06-2014 at 08:27 AM.
Hi djdjdj,
Thank you for your reply! Looks like it's working perfectly! Thank you! No I realised there is something wrong with my formula but at least vba part is doing the trick!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks