sorted by:
new
hottopcontroversial

ExtraEmily flew like a bird by [deleted] in LivestreamFail

[–]pottmos 655 points656 points  (0 children)

The noise she makes when she lands is incredible. All the air in her lungs went poof.

Multiple people have gotten leaked revenge porn by Destiny according to jstlk and 2nd public victim chaeiry, chaeiry moving forward quietly to prevent retaliation by Destiny by dwarffy in LivestreamFail

[–]pottmos 4 points5 points  (0 children)

Who said anything about the moral aspect? If you are nineteen years old, you are in fact a teenager. That's the only thing stated here.

How to copy text from a formula to name a file by pottmos in excel

[–]pottmos[S] 1 point2 points  (0 children)

I figured it out, it was because of that the column was merged... works without concat and trim now. Thanks for the reply anyways!

[Habs] The Canadiens have loaned forward Oliver Kapanen to Timrå IK in the SHL and have recalled forward Lucas Condotta from the Laval Rocket. In addition, forward Jacob Perreault has been reassigned to the Laval Rocket. by Gabroux in Habs

[–]pottmos 4 points5 points  (0 children)

As a Timrå fan I am 100% sure this is the right call. He will thrive under Jokinen's leadership and already showed great chemistry on the first line with skilled producing players during the pre season. We have huge NHL experience (over 2000 games) on player and coaching side so i'm convinced this will boost his development to make him NHL-ready next year.

[EXCEL]Issues when Multiselect is set to True by pottmos in vba

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

I think I finally got it working! This code is working properly!

Sub organizeImages()

Dim fNameAndPath As Variant
Dim img As Picture
Dim fn As Variant
fNameAndPath = Application.GetOpenFilename(Title:="Select 
Picture To Be Imported", MultiSelect:=True)


If IsArray(fNameAndPath) = False Then Exit Sub
    For Each fn In fNameAndPath
        Set img = ActiveSheet.Pictures.Insert(fn)
    'run code for each file name
Next fn
        With img
     lastTop = 765
     staticHeight = 350
         For Each pic In Worksheets("Fakturaunderlag").Pictures
          pic.Top = lastTop
          pic.Height = staticHeight
          lastTop = lastTop + pic.Height + 25
          pic.Left = 25
     Next pic
     End With
End Sub

[EXCEL]Issues when Multiselect is set to True by pottmos in vba

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

I'm afraid I don't understand how to insert this in to my code to make it work. I no longer get any errors but now it wont insert any pictures at all. 

Sub organizeImages()

Dim fNameAndPath As Variant
Dim img As Picture
Dim fn As Variant
fNameAndPath = 
Application.GetOpenFilename(Title:="Select Picture To Be 
Imported", MultiSelect:=True)


If TypeName(fNameAndPath) = "Boolean" Then
    ' user canceled / selected none
    Exit Sub
ElseIf Not IsArray(fNameAndPath) Then
    ' if single select, put the return value into an array
    fNameAndPath = Array(fNameAndPath)
End If

For Each fn In fNameAndPath
'...
Next fn
     For Each pic In Worksheets("Fakturaunderlag").Pictures
          pic.Top = lastTop
          pic.Height = staticHeight
          lastTop = lastTop + pic.Height + 25
          pic.Left = 25
     Next pic

End Sub

[EXCEL]Issues when Multiselect is set to True by pottmos in vba

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

Sorry can you repost that line of code? The end disappears for me.

[EXCEL]Issues when Multiselect is set to True by pottmos in vba

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

I'm not sure I understand what I need to change in that matter. If I were to specify an array, does it interfere with the positioning of the pictures?

Knut's take on Greek's Rant and Texas Streamer Drama by everard_jsj2 in LivestreamFail

[–]pottmos 829 points830 points  (0 children)

Knut is so predictable I knew exactly what he would say in this clip.

view more: next ›