I'm trying to select a whole column (and eventually only the filled
cells) by the text on its first row. The code I have by now is this:
--
For Each col In Worksheets
Select Case Columns.Name
Case "text-in-first-cell"
Columns.Select
Selection.Copy
MsgBox "The selection object type is " &
TypeName(Selection)
End Select
Next
--
It returns the error "Application-defined or object-defined error".
It's the first time I'm trying to code anything in
VB, so any help
would be very appreciated.
Thank you.
Duarte