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