+ Reply to Thread
Results 1 to 17 of 17

Copy a specific column data of filtered output without header

Hybrid View

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Copy a specific column data of filtered output without header

    It is not copying just one column. It is copying the the entire row.
    I used ColNo.column, instead of ColNo, because excel throws and error otherwise
    -------
    Set ColNo = Cells.Find(What:="Domain", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole, _
                        SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
                If Not ColNo Is Nothing Then
                    ColumnNumber = ColNo.Column
                    .Cells(1, ColumnNumber).Offset(1, 0).SpecialCells(xlCellTypeVisible).Copy  <------------This is copying entire row
    -------
    Last edited by arlu1201; 11-01-2012 at 09:25 AM. Reason: Use code tags in future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1