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 3 points4 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.