Dear Sir
How to insert a formula in a cell using vba
the formula is
=SUM(SIGN(FREQUENCY(IF(G5:G649>0,MATCH(B5:B649,B5:B649,0)),ROW(B5:B649)-ROW(B5)+1)))
but I have substitute the last cell G649, B649 every time with new cell number of G & B every where in the formula
G5 & B5 remains same in the formula
Last edited by SamManik; 05-27-2018 at 09:46 AM.
substituted them with what?Originally Posted by SamManik
What does your current code look like?
What cell does this formula go into?
if you use that as a string and put qoutation marks, it would do too...
example,
this would put that formula you have into cell A1
just take note. this is fixed. if you need the formula to be referenced into multiple cells like when you drag a formula across cells where the range becomes dynamic, this method i showed you will need to be modified a bit...
Please Login or Register to view this content.
don't worry, there's a lot of people that are far more confused than you
but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.
I have not coded yet
The formula is to be inserted in O5
Like G649 with G751 & B649 with B751 Or G841 and B841
the cell number in "G649" & "B649" changes in other wookbook
The cell number is user input and should be automatically substituted by the code
range("O5").formulaarray = (array formula) solved the problem
the thread is SOLVED, I do not the way to say it in title
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks