How to delete unwanted columns via macro for data analysis

1. Place 'X' in Row 2 in whichever columns you would like to delete.

2. Paste the following macro in Module.
(Insert > Module)

Sub del_columns()
Dim ws As Worksheet
Dim lastcolm As Long
Dim i As Long
For Each ws In Worksheets
With ws
lastcolm = .Cells(2, .Cells.Columns.Count).End(xlToLeft).Column
For i = lastcolm To 1 Step -1
If UCase(.Cells(2, i)) = "X" Then
.Columns(i).Delete
End If
Next i
End With
Next ws
End Sub

3. Press Alt+F8.

4. Click Run .

Error in removing adobe illustrator (trial version)

How to remove adobe illustrator CS3 components after installing the downloaded trial version ?
It states "User cancelled payload installation"

Clearing information in PC

How do I delete the historical information (besides deleting cookies, IE history , empty recycle bin) to ensure that my personal information / privacy is protected ?

Besides re-formatting the hard disk, are there any other ways ?

Why can't I open my Cognos impromptu report ?

1. You have not opened the right catalog. > Close the report and the catalog. Open the catalog and make sure the right catalog is selected. Then open the report again.
2. The catalog is corrupted. > Re-do the catalog; check if there is any other catalog that you can use; check if you have a backup.
3. The catalog is at a different location. > See 1.

Probability

1. In how many different ways can a true-false test consisting of 9 questions be answered ?


2. A pair of dice is tossed. Find the probability of getting
a) a total of 8.
b) at most a total of 5.

How to create a "pick from list" in MS excel?

How to create a "pick from list" in MS excel?

(something similar to combo box)