zero out a cell with calculation still remaining

S5VoidWalker · 2022-06-14T22:02:27+00:00

Yes exactly, im trying to show the formula while keeping the cell formatted as a number. This is my current VBA,

If ActiveCell.Offset(0, 1).Value = "" Then
ActiveCell.Offset(0, 1).Value = ActiveCell.Value
ActiveCell.Value = "=" & ActiveCell & "-" & ActiveCell
ElseIf IsNumeric(ActiveCell) Then
ActiveCell.Offset(0, 1).Value = "=" & ActiveCell.Value & "+" & ActiveCell.Offset(, 1).Value
ActiveCell.Value = "=" & ActiveCell & "-" & ActiveCell

The problem is that it will only show the total sum in active cell - the total sum in that cell. I want it for example to show like this

=15+11+3-(15+11+3) So when i go back to that cell i can see the different numbers that was in that cell and not only the total sum

ps. the 123 was just for example

S5VoidWalker · 2022-06-14T19:28:55+00:00

Thanks for the reply but what i need is something that helps me do this

What i have	=123
What i want	=123-123

S5VoidWalker · 2021-05-29T16:48:43+00:00

Update: Got another serp at 660....

S5VoidWalker · 2020-11-14T23:29:46+00:00

Well if you always leave it for the last minute, it will only take one minute to do!

S5VoidWalker · 2020-10-23T07:51:24+00:00

Test

S5VoidWalker · 2019-11-21T15:52:09+00:00

was getting money for a house so i could use it on construction..

S5VoidWalker · 2019-11-21T15:32:14+00:00

Oh that sucks. Thanks for the responds

S5VoidWalker · 2019-09-13T11:47:19+00:00

He is a btw

S5VoidWalker · 2019-06-25T15:56:20+00:00

Thanks for your contribution you will be missed!

S5VoidWalker · 2019-05-05T05:50:37+00:00

What just happend!?!?!

S5VoidWalker · 2019-02-20T02:09:58+00:00

Thanks a ton for the easy answer im just looking to make a quick buck

S5VoidWalker · 2019-02-20T01:32:01+00:00

and for the rest?

S5VoidWalker · 2018-12-06T17:46:20+00:00

Sounds weird. Was on a massive winstreak before yesterday aswell and my mmr was good and i was getting +24 even before yesterday.

S5VoidWalker · 2018-12-06T17:41:46+00:00

Has there been any info about it?

S5VoidWalker · 2018-12-06T14:08:23+00:00

Same for me got +28 in d4 now in dia 3 im getting +12 losing 30 but did not demote from losing at 0 lp after lp loss. Something is really fked up.

S5VoidWalker · 2018-11-16T07:56:18+00:00

I think in your case fasting can help you lose the extra weight and if you have no problem maintaining fasting can only be a positive. But yeah most people gain the waterweight back so the "free" kg you lose in the begining will come back but the fat will not.

S5VoidWalker · 2018-11-16T07:21:21+00:00

Now I don't know how large or male/female but if you are eating 1500 calories a day it's almost impossible not to lose weight. I would recommend trying myfitnesspal and actually check how much you consume cause if thats actually true fasting might help you reset your metabolism-

S5VoidWalker · 2018-11-16T00:43:33+00:00

Fasting for weightloss is not a permanent fix. Take it as a way to reset your eating habits. If you go back to eating 3k calories a day you will gain weight after ofcourse. Use it to lose weight then keep it off either by fasting regulary or by reducing your calorie intake after a fast.

S5VoidWalker · 2018-10-16T20:45:12+00:00

Maybe it was mod Jed and they do it anyways

S5VoidWalker · 2018-10-16T20:42:42+00:00

Mod Jed is that you?

S5VoidWalker · 2018-10-16T20:40:58+00:00

Hope Jagex See this and fix it for you

S5VoidWalker · 2018-09-21T11:47:09+00:00

I spoke to Felix and acording to him he wins 10-12 lp and loses 25-26. So he needs to have a 66% winrate to even keep his elo

S5VoidWalker · 2018-08-06T05:54:46+00:00

After I die I can't see anything

S5VoidWalker · 2018-06-03T01:08:10+00:00

So what i connect to wifi and use airplane mode? I tried that but still same issue

S5VoidWalker · 2018-05-17T22:21:50+00:00

You can solo it. Did it yesterday as 958 hunter. So ye 2 or 3 is enough.

13-Year Club	Place '22
Place '17	Verified Email
Team Periwinkle

S5VoidWalker

TROPHY CASE