LinkBack URL
About LinkBacks
I hav the data like below...
A B C =sum(A1,B1) 1 2 3 4 5 6 7 8 9 10
How can i create the macro to excute the formula in C1 to the entire column cell when detect A & B hav value???
I hav the data like below...
A B C =sum(A1,B1) 1 2 3 4 5 6 7 8 9 10
How can i create the macro to excute the formula in C1 to the entire column cell when detect A & B hav value???
Isaac Koh
Doesn't that formula copy ITSELF down column C when you double-click the lower right corner of that cell?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Please Login or Register to view this content.
If solved remember to mark Thread as solved
tq.. its work.. but is tat I can set the entire cell formula will follow the formula in cell C1?Originally Posted by patel45
Please Login or Register to view this content.
Hi, isaackoh,
Ciao,Please Login or Register to view this content.
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
Personally I would go with HaHoBe's suggestion which uses no Looping.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
For a start, you dont need to use =SUM() for thiws, you could just use =A1+B1
And if you convert this into an excel Table, then when you enter new data, the formula will copy itself down with no moacro needed
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
@ FDibbins,
Hello my Maat,
This is unfair, you always seem to be one up!
Why did I not think of that? It is a good suggestion, and if you don't want any Zero's to show, one could enter your formula as: =IF(A1+B1=0,"",A1+B1).
Well done,
Kind Regards.
@ Winon, dankie vir die lekker worde
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks