Thread
:
To find the column with its column heading
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
Posts: 11,058
To find the column with its column heading
Sub insertCol()
For i = 1 To Columns.Count
If Cells(1, i).Value = "STOCK CODE" Then
Cells(1, i).EntireColumn.Insert
Exit Sub
End If
Next
End Sub
--
Gary''s Student - gsnu200806
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student