I have a final number that is derived from many cells in excel generated firstly from =Rand(). What I want to do is add that number to the total of all previous running totals and so on. However I have run into a snag every time i try and make the Target.Address = "that cell" it does nothing. What am I doing wrong here can anyone help?
Hi
We need to see the code in the context of its workbook
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you are using Target.Address then VBA will be trying to set the Address of the range Target, Address is a read only property of Range so you can't change it.
To put a value in the range Target use Target.Value.
If posting code please use code tags, see here.
Here is the Code
Please Login or Register to view this content.
That code should work, are there any errors, unexpected results?
I can link the number from one cell to C5 without error but the total of C5 does not add to C6 except for the first time I activate the code or put a number directly into C5.
That code will only add to C6 when you manually enter something in C5.
What is it you want to do?
Is C5 a formula?
What sort of 'link' are you referring to?
Hi,
That code works for me. Whether it's doing what you want it to do is a moot point.
i.e. starting with C5 and D5 empty, successively entering 1,2,3,4.. etc in C5 results in 1,3,6,10...etc. in D5
Oops, meant D5 not C6.:oops:
C5 is the end result of a formula yes. Formula in excel is;
K2=RAND()<=.23 K2=IF(K2=TRUE,RAND()) M2=L2*2000*RAND() N2=RAND() O2=M2*N2
sorry dont know how to add excel cells in the forum just yet. This is being used for a random generator for pounds of gravel of certain types estimated per day and the amount of usable material within said gravel.
Hi,
I don't understand. You seem to be implying that C5 gets its value from K2. But the formula you show for (presumably K2) is not understandable and in any case seems to be self referencing and therefore circular. Not sure where M2:O2 enter the debate.
Upload the workbook (the FAQ tells you how) and add some notes which clearly describe what you want to do, and manually add add some typical results so that we can see your goal.
The formula can be interchanged so the only problem I am having is using a formula say =Rand() as C5 in the VB code simply put. how can I get VB to work with a randomly generated number without manually inputting it?
Hi,
Perhaps by using the VBA Rnd syntax?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks