Code works the 1st time, but not the 2nd time

This code just works on the first time because when It's activated again, It'll try to sum a function, not the value from this function.

For example:
First try
User enters 100 on J" & lrTest - 1 &
G6 = 0
Then it'll be =sum (0, 100) that is equal 100.
But on the second try it'll try to sum the function and won't go on.

Please Login or Register  to view this content.

What can I do to solve it?

Ps: I guess you don't know the full code, but if needed, I can post it.

This is my workbook:
cbb2d65.png

That code doesn't compile.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

I don't follow your description.

Remove the quotes from around the "G6" in the formula.

Please Login or Register  to view this content.

But then the code is putting a formula in cell G6 and the formula references cell G6 which creates a circular reference.

I should work like a "count" function. For example: every time the code runs this function, It should add 1 to itself (count = count + 1). In my case, every time the code runs through this "code" (because that's just a copy/paste from the full code - which I think It won't be needed. If it does, I can post it here), J&lastrow -1 should be added to G6. So it would be, basically, G6 = G6 + J&lastrow - 1 (-1 because I don't need the last row, but the row before the last one).

Ps: I need it to change the G6 data when I change something on J column. So I think it needs to be a function.

Perhaps something like this...

Please Login or Register  to view this content.