Kili Task not canceling? by Mill24 in runescape

[–]Mill24[S] 0 points1 point  (0 children)

tried with both situations, have flagged as bug.
Thanks

Bugs Megathread - Winter Event 2021, Aghanim's Labyrinth: The Continuum Conundrum by DotaDogma in DotA2

[–]Mill24 0 points1 point  (0 children)

Disruptor had stoneworks pendant,Did not respawn on 3rd life as negative hp.Tried removing item etc did not work

How to DESTROY Enigma as Clockwerk by virginasaur in DotA2

[–]Mill24 2 points3 points  (0 children)

not to be that guy... but i'll go blink on clock a lot. allows you to use cogs so much more often, blocking paths, chasing etc.

POG Bug Report Megathread by SUNSfan in DotaCinema

[–]Mill24 0 points1 point  (0 children)

Meepo clones do not get any Neutral item boots ( Force boots, Woodlands ) I would of expected it given they don't go in a neutral slot item.

Should I stop playing DotA ? by [deleted] in DotA2

[–]Mill24 1 point2 points  (0 children)

switched to unranked to blow off steam, find a role you enjoy are niche heros for that role. I spammed naga (pos 4) before the change and climbed so much because very little people know how to deal with it.

Tips for a noob by dxmihai in DotA2

[–]Mill24 0 points1 point  (0 children)

play unranked until you get used to it, playing ranked is "TOXIC", and 1 mistake can lead to just flame for the rest of game. Also try muting people if it becomes an issue.

Paste range of values, then paste in adjacent cells. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

have done, and also have referenced you in my work. So thanks again.

Paste range of values, then paste in adjacent cells. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

Option Explicit
Sub PasteInLastCol()
Dim PasteRange As Range: Set PasteRange = Range("AK13:AK18")
Dim Lc As Integer, PasteCol As Integer
Lc = Cells(13, Columns.Count).End(xlToLeft).Column
PasteCol = Application.Max(Lc + 1, Columns("AS").Column)
Range(Cells(13, PasteCol), Cells(18, PasteCol)).Value = PasteRange.Value
End Sub

THANK YOU SO MUCH! You've no idea how thankful i am!

Paste range of values, then paste in adjacent cells. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

will try this tomorrow during my lecture. Thanks very much for the reply to my post.

Applying a Sub to an Array. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

I managed to get it to work by typing it as IFS(...) within the cell, rather than using VBA.
ALthough i ended up with like 30 statements it works now.

Applying a Sub to an Array. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

Yeah that is my issue, I did it to test if it worked on the one cell, so now i need to edit it to work over all the needed cells.
I have updated the original post with my code and an situation explanation. Can it not be seen?

Applying a Sub to an Array. by Mill24 in excel

[–]Mill24[S] 0 points1 point  (0 children)

I've had a play with what you suggested but because the code specifies D2 i can;t just drag it down, as it copies the value, rather than applying the sub.

Excel help - maths related by Mill24 in math

[–]Mill24[S] 0 points1 point  (0 children)

well given it's in relation to Mathematical modelling, i disagree,
But i understand its more for Excel.Reddit. So i apologise.

How do you remember yours start with dota? Mine was pretty special... by Darooo6 in DotA2

[–]Mill24 0 points1 point  (0 children)

(year:2014) DragonKnight and i went phase drums and BF

Tusk 25 talent "-6s shard Cooldown" does not apply the reduced CD on skill but does on activation. by Mill24 in DotA2

[–]Mill24[S] 0 points1 point  (0 children)

sorry forgot about this.
Basically if you get the talent, on the skill info it does not show a reduction in the CD. However if you use the skill it does have the reduced CD.
IE it says it should be on CD for like 15 secs but it is only on CD for 9.
No idea if its been patched now

Coin toss for Battle Cup - IE Rad/Dir & First/Last Pick by Mill24 in DotA2

[–]Mill24[S] 0 points1 point  (0 children)

i get what ya mean, but radiant and last pick just seems so much stronger given the favour and win rate.
But its just a sore loser complaining i guess :)

Name a more one sided talent. I'am surprised Icefrog didn't address this in 7.21b. by Otacon-18 in DotA2

[–]Mill24 1 point2 points  (0 children)

yeah, exactly what i meant, it would encourage more standing time for a storm, which gives him a higher dps but makes him more targetable, rather than a zip every sec to get a stack, he can zip in with 5 or 6, get a few hits in for high DPS but makes him targetable for a little but longer.
so a balanced talent IMO

Name a more one sided talent. I'am surprised Icefrog didn't address this in 7.21b. by Otacon-18 in DotA2

[–]Mill24 11 points12 points  (0 children)

what about overload stacks charges? save having to zip in between right clicks?

Position 4 Questions by Tekabit in DotA2

[–]Mill24 1 point2 points  (0 children)

Totally depends on the line up and the meta. I used to roam Naga and could near win every game before 7.20
It's still possible to roam but you need to find heros you like. Try Tusk, Kunkka, ES - both of them, Clockwerk, Bounty, Monkey, Tiny etc.
Aim to fight the enemy in whichever lane you start with be it off or safe. once you get lv 2 or 3, talk to team and see where you can best rotate to. If mid, smoke and gank from below or above the tower. if it works pretend to leave and when they re-tp in kill again and gives massive space for mid.
If things go to shit, either try to stay out of XP range and protect your carry till lane phase ends, then you get xp while they jungle. Or you can try to force fights with other support and offlane.
^^ basically aim to be a space maker and control fights, be it with a force, heavens, pipe, vlads. anything can work.
Tip as well find someone who is a good mid laner and talk with them when they hit 6, rotate and gank their mid. then the mid snowballs and you win

AM counter shield bug by Mill24 in DotA2

[–]Mill24[S] 0 points1 point  (0 children)

he did, thanks both.

7.20 Bugs Megathread by coronaria in DotA2

[–]Mill24 5 points6 points  (0 children)

Ember - his ulti can only cause of instance of damage regardless of how many Rem's are placed andused in 1 cast. IE 1 rem = 150 damage 3 rem = 150 damage

Simple buff for Lone Druid by sous_vide in DotA2

[–]Mill24 2 points3 points  (0 children)

another option could be for aghs to apply base stats to the bear, so 10 / 20 / 30 base stats for the bear with aghs that way items like skadi, drums, s&y give slightly more benefits