10 Largest Holes Swallowing The Earth

Amazing People With Real Super Powers

Top 7 Best Eagle Attacks (GRIZZLY,KANGAROO...& MAN)

Eagle hunting Mountain Goat - King of the Sky

World most Shocking Video that made the whole world cry

Dubai Marina Walk UAE-Day and Night

Dubai Miracle Garden 2016

Top 15 Places to See in Istanbul, Turkey

Dubai : 10 Must Visit Places

Cricket Funny Moments Top 20 Funniest Moments in Cricket History Ever

10 Of The Best Fights In Cricket History

Unbelievable Animals That Saved People's Lives

Top 10 Scariest Places You Shouldn't Visit

Top 10 Most Dangerous Children's Toys Ever Made

Top 10 Biggest Dogs In The World

Top 10 Strangest Houses In The World

Top 10 Richest Cricketers in the World 2016.

World Top 10 Best Military Commander Generals In The World 2016

Top 10 Richest Actors in the World 2016

Top 10 Most Expensive Cars In The World 2016

Top 5 Most Expensive Houses In the World 2016

TOP 10 Footballers in the World 2016 !

GESF 2016 - Global Teacher Prize (Winner announcement)

Palestinian teacher Hanan Al Hroub wins Global Teacher Prize 2016.

Samsung Galaxy S7 and S7 edge: Official Introduction

T20 World Cup 2016 All Teams Squad & Player list

Top 10 Richest People in the World 2016

Oscar 2016 | FULL SHOW Highlights

Ahmed Chawki feat. Pitbull - Habibi I Love You

Final Of PSL in Dubai.

https://photos.google.com/share/AF1QipOghrn1MVan3OaYNXycQ_sceQH7QGs1u8DVm8ejiGTNw7VHIUdr5SxZ5g8KEtIvFw/story/AF1QipMcIdBwLRNHh-AbH6IQzmuEBxLO73kJakgasxoHZc8KHSBmf5Aj5pbN8Z8Mk0HGQA?key=VmpBeUhkbW5jcE9jcVU3NExodS1XZXFNNS1HODZn

https://goo.gl/photos/eeD8tg12b8Bab7pf6

Pakistan Super League Official Anthem

10 Most Dangerous Sports

LAST Over* PSL T20 2016 1st Playoff Peshawar Vs Quetta 19 February 2016

Hail storm Hits in Dubai Today Evening 17-02-2016

Hail storm in Dubai

Light Tunnel-Sharjah Light Festival-

Frozen Gangnam Style.

Snow fall in Murree and Islamabad,12 February 2016

Heavy Snow fall in Abbottabad ,12 February 2016,

Sharjah Light Festival 2016

Light Festival 2016 Sharjah.

Light Festival 2016 Sharjah.

@PSL FEVER - Arif Lohar Live in Concert

PSL - Pakistan Super League 2016 Opening Ceremony Sean Paul Performance

Pakistan Super League Opening Ceremony -

PSL FEVER - Mohammad Amir First Hat Trick on PSL 2016 Karachi Kings vs Lahore Qal...

PIA Karkardagi,

Hum Sab Umeed se hain ....

Agar PIA privatise ho gaye ,,,

iPhones - Futures iphone Could Be Controlled Without Touch

10 Smallest Countries in The World

The World's Future MEGAPROJECTS (2015-2030's)

Amazing Things You'll Only See In Dubai

10 Unbelievable Underwater Buildings

Top 10 Amazing Places On Earth You Won't Believe Are Real

The Most Dangerous Selfies Ever Taken

10 Deadly Natural Disasters Caught on Video

The Most Beautiful Places in the World

The Top Ten Most Beautiful Roads in the World .

TopTen Most Beautiful Cities in The World 2016.

Top 10 Richest Royals in the World 2015

Top 10 Richest People in the World 2015/2016

Atif Aslam, Tajdar-e-Haram, Coke Studio

Hazrat Ali (A S) Home in Makka Mukarma, Saudi Arabia

Hazrat Halima Ka Ghar Taif

UAE covered with snow has created the history.

Bayan-e-Quran-Dr. Israr Ahmad-Surah - 002 AL BAQARAH 075 - Part 6

Bayan-e-Quran-Dr. Israr Ahmad - 002 Surah AL BAQARAH 030 TO 046 - Part 4

Bayan-e-Quran-Dr. Israr Ahmad-Surah - 002 AL BAQARAH 047 TO 074 - Part 5

Snow falls in Kuwait for 'first time ever

20 meters of snowfall in Hokkaido

World's Most DANGEROUS Route Ever... !!!

10 Most Dangerous Airports In The World

TOP 5 Mysterious Creatures Caught By NASA On Mars

Sairbeen 25th January 2016.BBC Urdu

Inside Story by Dr. Shahid Masood on General Raheel Sharif’s Extension.

Shocking aerial footage of the aftermath of the US blizzard

Pakistan a heaven on earth

Beautiful Pakistan Full with Nature

Top Ten Most Beautiful Places in Pakistan

MASSIVE BLIZZARD BLANKETS EAST COAST today 24 Jan 2016

Major snowstorm in the East Coast .USA.

Snow Fall & Cold Weather in USA

Hisham Abbas an arabic singer makes a mix song with pakistani young boy Muhammad Shahbaz Suba

Abida Parveen & Rahat Fateh Ali Khan, Chaap Tilak, Coke Studio Season 7

Kaash Mein Door e Muhammad Mein Uthaya Jata - Farhan Ali Waris

Funny Conversation Between Momo & Anwar Maqsood

Anwar Maqsood & Hina Dilpazeer Awesome Stage Performance

Masjid Open For Cats In Turkey Due To Snowfall

Sardar A.J Sing first Sikh in Pakistan Rangers appointed at wahga border Lahore.

Aye Wattan Pyare Wattan

Adeel Shaikh Presents - Journey from Surgery to recovery

Maulana Tariq Jameel bayan on 13 march 2014

Maulana Tariq Jameel bayan on 13 march 2014

Maulana Tariq Jameel latest bayan in Saudi Arabia Al Khobar 27/03/2014

Abia Nursery Graduation

Compression utilities comparison

we are normally having discussion related to compression utilities. following is my finding for this topic, using compression utilities ( 7z, WinRar, Windows compression)

Adding Dynamic Column to Excel

Adding Dynamic Column to Excel
Following function will add one column at  location D for all the sheets in opened excel document.

Sub AddColumnUPdateHeader()


For X = 1 To Worksheets.Count
 Sheets(X).Select
 Columns("D:D").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove


Next X

End Sub

Macro for Excel to get Count and Names of Sheets of excel documents

Following routing will update Cell B2 with count of total numbers of sheet and Update Column C with names of sheets.

Sub ReadNames()

Range("B2") = Worksheets.Count

For X = 1 To Worksheets.Count

Range("C" & X).Value = Worksheets(X).Name

Next X

End Sub