Hello,
How do you write a code that will calculate a formula and output the result in a cell?
For example:
A1 = 1 (Named "Cell1")
A2 = 2 (Named "Cell2")
A3 = Results of macro for Cell1+Cell2 = 3
Is there a way to write it if I also want B3 = B1 + B2 and C3 = C1 + C2, etc.
Thanks.
Can you be more specific?
It may be that a FUNCTION which accepts parameters is appropriate, then you can use it like any regular Excel function, in a cell / range of cells, by passing relative cell references as function arguments...
Hard to say without understanding what the code is doing, though.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
How about doing it just the way you have it there?
In B3, type in =B1+B2
Then copy that across
whatever you put in B1 and B2 will ve added up and shown in B3
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks but that's not a macro.
I need to write a more complicated macro that gives the results of a COUNTIF statement for multiple variables.
We'd love to help
Here you go, OllyXLS:
http://www.excelforum.com/excel-prog...ml#post3584926
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks