Excel VBA – delete all blank columns without any content

This is a function to identify when the column(s) doesn’t have any content in each cell, then delete that entire column(s).  It is a amazing function to clean up your spreadsheets before modifying your data.

Function DeleteBlankColumns()
Dim Col As Long, ColCnt As Long, rng As Range

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

On Error GoTo Exits:

If Selection.Columns.Count > 1 Then
Set rng = Selection
Else
Set rng = Range(Columns(1), Columns(ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Column()))
End If
ColCnt = 0
For Col = rng.Columns.Count To 1 Step -1
If Application.WorksheetFunction.CountA(rng.Columns(Col).EntireColumn) = 0 Then
rng.Columns(Col).EntireColumn.Delete
ColCnt = ColCnt + 1
End If
Next Col

Exits:
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

End Function

Spring whisperings…

Upon reaching the Sakuranomiya JR (Osaka) station, the reports that the cherry blossoms (Sakura) were appearing slightly later than average this year proved quite true.  However, pleasantly, my visit was not greeted with complete disappointment. While strolling through the Sakura Kema Sakuranomiya Park (毛馬桜之宮公園), I was elated when I spotted .. faintly .. here and there … a few peeping cherry blossoms, shyly unfolding their translucent pinkish wings … quietly whispering the beginning of the Sakura season .. for the Osaka region ..

With renewed determination … I quickened my steps and finally … right before me … in one end of the park, a lone sakura tree blooming prettily ….. and catching quite a few passersby’s admiration and smiling photo snaps indeed !! 

Date: 29 Mar 2017

Lights show in Hong Kong Flower Show 香港花卉展覽燈光 2017


Themed “Blossoms of Love”, the Hong Kong Flower Show 2017 showcases the rose as its spotlight flower and Hong Kong as a beautiful city of love. The installation will combine lighting effects, 3D effects and multi-media.

今年香港花卉展覽主題為「愛‧賞花」, 並以美麗可愛的玫瑰為主題花,展現香港是一個美麗充滿愛的城市。為配合大會的主題,展品運用燈光效果、互動元素、三維(立體)藝術效果及多媒體以配合展品,以增加花展的吸引力。

Date: 16 Mar 2017

Hong Kong Flower Show 2017…

It is the entrance of the Hong Kong Flower Show 2017, the logo comes with different color LED, please come and visit the show in Victoria Park, Causeway Bay…

The Hong Kong Flower Show is a major event organised by the Leisure and Cultural Services Department to promote horticulture and the awareness of greening. Every year, it provides a good opportunity for hundreds of thousands of local citizens and horticulture lovers all over the world to appreciate the beauty of flowers and share their experiences in the cultivation of flowers. Hong Kong Flower Show 2017 will be held from 10 to 19 March 2017 at Victoria Park in Causeway Bay. With “Blossoms of Love” and the adorable “Rose” as its theme and theme flower respectively, the Hong Kong Flower Show 2017 will project Hong Kong as a beautiful city where love is in the air. Featuring “Rose” as its theme flower, the event will showcase this exquisite plant and a rich profusion of exquisite potted plants, beautiful floral arrangements and gorgeous landscape displays by organizations from local, the Mainland and overseas. There will also be commercial stalls selling flowers and other horticultural products.

香港花卉展覽是康樂及文化事務署推廣園藝和綠化意識的重點項目。每年為數十萬本港市民和世界各地的園藝愛好者提供一個賞花和交流種花經驗的良機。二零一七年香港花卉展覽將於二零一七年三月十日至十九日在香港銅鑼灣維多利亞公園舉行。大會以「愛.賞花」為主題,並以美麗可愛的「玫瑰」為主題花,展現香港是一個美麗和充滿愛的城市。市民除了可以欣賞到顏色奪目的主題花「玫瑰」及各地的花卉之外,更可以觀賞到來自本地、內地及海外園藝機構展出悉心栽培的盆栽、造型優美的花藝擺設,以及色彩繽紛的園景設計。會場更設有售賣花卉及其他園藝產品的銷售攤位。

Date: 13 Mar 2017

Chinese Lion Dance for shops… 紅磡紅青堂醒獅賀商舖

https://www.facebook.com/儒釋道三聖寶林紅青堂-126064110806119

Chinese Lion Dance in Hunghom, Hong Kong, this is celebration to surrounding shops, restaurants, and wish them good luck and good business.

by 紅青堂醒獅

在香港,舞獅又稱醒獅,逢年過節,如天后誕辰,或是店鋪開業,都有醒獅表演的傳統。

醒獅被認為是驅邪避害的吉祥瑞物,每逢節慶,或有重大活動,必有醒獅助興,長盛不衰,歷代相傳。

Date: 11 Mar 2017

2016 Nouvel An Paris, Champs Elysées, Arc de Triomphe

On a new year eve, it is a tradition to gather at the Champs-Elysees, the Eiffel Tower and the Trocadero in Paris. These gatherings are expected especially at the Arc de Triomphe and under the Eiffel Tower. But for security reasons, no major event will be organized.

No fireworks will be fired, but a projection mapping show will be screened from 11:30 pm on the façade of the Arc de Triomphe.

Date: 2016.12.31 -2017.01.01

 

2015 Nouvel An Paris, Champs Elysées, Arc de Triomphe

Each year, hundreds of thousands of people gather on Paris’s Champs-Elysées to celebrate the “Réveillon,” as the French call December 31.

The light-and-sound show at the Arc de Triomphe will start at 11:50pm and be cut to ten minutes, as opposed to last year’s 20. The main objective is to avoid large crowds gathering for too long. Large screens will transmit the spectacle, and while the Champs-Elysées will be closed to car traffic as usual, circulation will be restored sooner than in previous years.

Date: 2015.12.31 – 2016.01.01

Pachelbel’s Canon In D Major… Violin and Cello

https://www.facebook.com/nopermitmelbourne/

Two old school friends that share a similar vision and taste in music who partnered up in the beginning of 2017 to perform covers and originals in the style they love to perform.

Pachelbel’s Canon, like Pachelbel’s other works, although popular during his lifetime, soon went out of style, and remained in obscurity for centuries thereafter. A 1968 arrangement and recording of it by the Jean-François Paillard chamber orchestra became unexpectedly popular over the next decade, and in the 1970s the piece began to be recorded by many ensembles; by the early 1980s its presence as background music was deemed inescapable.[1] From the 1970s to the early 2000s, elements of the piece, especially its chord progression, were used in a variety of pop music songs. Since the 1980s, it has also been used frequently in weddings and funeral ceremonies in the Western world.

Date: 20 Feb 2017

U2 With or Without you in violin and cello

https://www.facebook.com/nopermitmelbourne/

Two old school friends that share a similar vision and taste in music who partnered up in the beginning of 2017 to perform covers and originals in the style they love to perform.

See the stone set in your eyes

See the thorn twist in your side

I’ll wait for you

Slight of hand and twist of fate

On a bed of nails she makes me wait

And I wait without you

With or without you

With or without you

Through the storm, we reach the shore

You gave it all but I want more

And I’m waiting for you

With or without you

With or without you

I can’t live with or without you

And you give yourself away

And you give yourself away

And you give, and you give

And you give yourself away

My hands are tied, my body bruised

She got me with nothing to win

And nothing left to lose

And you give yourself away

And you give yourself away

And you give, and you give

And you give yourself away

With or without you

With or without you

I can’t live

With or without you

With or without you

With or without you

I can’t live

With or without you

With or without you

Date: 20 Feb 2017

How to make Green tea ice-cream rolls… Cream’d ice cream in Sydney

Cream’d Ice Cream is based in Sydney serving Thai-inspired ice cream rolls. This concept is ice cream made on a cold plate with a combination of serving fresh and made-to-order ice cream with individual characteristics right in front of your eyes.

With ice cream made from its rawest form, cream liquid is poured on a cold plate that instantly freezes the base to roll into ice cream rolls, then topped with fresh fruits and sweets with the final touch of cream’d.

At Cream’d we strive to achieve in creating more & more flavours with each having a unique modern twist to it.

Roll it, Top it, Cream it!

Now they have a pop up store in Westfield Sydney CBD basement foodcourt.