a couple of laughzillas on a blue diamond background

IDC: Samsung shipped more smartphones in Q1 2014 than Apple, Huawei, Lenovo, and LG combined

Apr30
by on April 30, 2014 at 1:50 pm
Posted In: Around the Web, Gadgets, Google, Mobile

Samsung OLED
Apple may be smartphone king in the US, but Samsung is absolutely undisputed worldwide. In Q1 2014, the South Korean company shipped more smartphones than the next four vendors combined: Apple, Huawei, Lenovo, and LG. Smartphone vendors shipped a total of 281.5 million smartphones worldwide last quarter, up 28.6 percent from the 218.8 million units in Q1 2013, but down 2.8 percent from the 289.6 million units shipped in Q4 2013. Smartphones accounted for 62.7 percent of all mobile phone shipments in Q1 2014, up from the 50.7 percent of all mobile phone shipments in Q1 2013. The latest quarterly…

This story continues at The Next Web

└ Tags: ,
a couple of laughzillas on a blue diamond background

Britain’s Mint.com, Money Dashboard, rolls out mobile apps to help you track your finances

Apr30
by on April 30, 2014 at 1:26 pm
Posted In: Apps, Around the Web, Insider

Money-UK2-645x250
Way back in May 2010, we queried whether Money Dashboard could become the UK’s answer to Mint.com, a question we were still asking by the time of its relaunch two years later. Now, the Edinburgh-based startup has answered at least some of these questions with the launch of its very first native mobile apps, available for Android and iOS. A mobile-optimized site actually went live last month, and we knew these native incarnations were on the way, so this doesn’t come as a completely surprise. But with so much emphasis these days placed upon managing one’s finances on the move,…

This story continues at The Next Web

└ Tags: 
a couple of laughzillas on a blue diamond background

Heyku’s digital sticky notes app rebranded ‘Ku’, adds option to share to Tumblr and save drafts

Apr30
by on April 30, 2014 at 12:06 pm
Posted In: Apps, Around the Web, Insider, Product Updates

facebookad_camera1
Heyku, the app that allows users to express themselves by posting updates with photos, short lines of text, sounds and doodles, has launched a rebuilt version of the platform that brings a new name as well as new features. From today, the app will be known simply as Ku and users now have the option to share their expressive sticky notes to Tumblr, as well as previously supported social networks like Twitter, Facebook and Instagram. Ku said that it had also redesigned the look of the updates to make them “even more beautiful and engaging” than before. “Ku was inspired by the…

This story continues at The Next Web

└ Tags: ,
a couple of laughzillas on a blue diamond background

BT Sport will be free to UK broadband subscribers for a second football season

Apr30
by on April 30, 2014 at 11:34 am
Posted In: Around the Web, Insider, UK

Good news for UK football (soccer) fans – BT Sport will remain a free add-on for both new and continuing BT Broadband customers for at least another season. Though BT covers a number of sports including Moto GP, it’s the coverage of the English, Scottish and other European football leagues that will perhaps appeal to most people. The company says that three million homes now subscribe to BT Sport directly from BT, be it through BT TV or the BT Sport mobile app, and around two million more access the service via deals struck with partners including Virgin Media. ➤…

This story continues at The Next Web

└ Tags: ,
a couple of laughzillas on a blue diamond background

Copy Selection Sum to Clipboard

Apr30
by on April 30, 2014 at 11:30 am
Posted In: Around the Web, Copy and Paste, Keyboard

Last month I posted some metrics on the keyboard shortcuts I use. One of the pieces of code that I could not link to (because I’ve never posted it) is CopySum. I don’t remember what prompted me to write this little procedure, but it has been surprisingly useful. It sums the selected cells and puts that sum into the clipboard. That’s all it does.

Sub CopySum()
   
    Dim doClip As MSForms.DataObject
   
    On Error Resume Next
   
    gclsAppEvents.AddLog "^+c", "CopySum"
   
    Set doClip = New MSForms.DataObject
   
    If TypeName(Selection) = "Range" Then
        doClip.SetText Application.WorksheetFunction.Sum(Selection)
        doClip.PutInClipboard
    End If
   
End Sub

If I want to get a one-off sum of something and use it in another program, this comes in handy. I could SUM in a cell, copy that cell, paste it, and delete it. If I paste into Notepad, it’s fine, but if I try to paste into Outlook or even Gmail those programs try to get fancy and make an HTML table. Sometimes I just want the text.

One shortcoming of this procedure is that it doesn’t do well with filtered cells. The Selection includes both visible and hidden cells, but I probably only want visible. I’m changing the code to

doClip.SetText Application.WorksheetFunction.Subtotal(9, Selection)

so it works with filtered data.

└ Tags: