Hi All,
I am trying to create a macro that does exactly as the following formula:
What I've tried so far is this:
Please Login or Register to view this content.
but unfortunately it returns a #VALUE! error. How can I manage to change it so it returns the actual value as per formula? Also, it should be calculated to the last row in T column.Please Login or Register to view this content.
Best regards,
Paul
Try starting by recording a macro in which you enter the formula into a cell. Review the recorded code.
It will likely do the formula in R1C1, alternatively look at the range.formula method here
Lastly, you can use many sheet functions via Application.Worksheetfunction.functionname...however this has some limitations and is generally more difficult to work out for complex functions than above recommendations.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
ok, So I've tried the following code:
But there are 2 issues:Please Login or Register to view this content.
1. After the calculations it shows up as the formula not as the actual value so I need to use text to columns ( Text to Columns - Finish).
2. The calculated result of the first cell is dropped down, not the formula.
And I do not have any ideas how to make it work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks