View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
WintonCW WintonCW is offline
external usenet poster
 
Posts: 1
Default Apply Macro to Specific Column (Answered my own question)

Thanks -- this is the code that works::

Dim myCol As Long
Dim myCell As Range

Set myCell = Cells.Find("Code")

If Not myCell Is Nothing Then
myCol = myCell.Column
End If

For Each c In Columns(myCol).Cells
.....
Next c