Results 1 to 6 of 6

Thread: Version 2003 to 2007

  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14

    Version 2003 to 2007

    Hi,

    This is a macro in Excel 2003 version, as you can use in Excel 2007 ...
    On the first page there are items to be searched, according to the criteria and where the export
    now reports: Debug

    Code:
    Sub Macro2()
        Dim RigaDati As Long
    '---I am looking for the last row to search...
        RigaDati = Sheets("Dati").Cells(Rows.Count, 2).End(xlUp).Row + 1
        
    '---This code performs an advanced filter on the data sheet: "Dati"
        Sheets("Dati").Range("A2:J" & RigaDati).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("ricerche").Range( _
            "A7:J19"), CopyToRange:=Sheets("ricerche").Range("O2:X2"), Unique:=False
    End Sub
    Unfortunately I have available to Excel 2007 - 2010 for testing

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    I'm not clear. In which line you get error ?

    Can you attach a workbook ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Hi

    Following attachment, no sensitive data:
    Download Filter.zip from Sendspace.com - send big files the easy way

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Can you please upload the file here ? Users won't like to download the files from external source.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  5. #5
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Hi,
    Gold I found how to attach the file regularly feature in Excel version 2003.
    What I do not know how to do it for later
    Attachment 154

  6. #6
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    What's the error. It works fine in Excel 2003 and 2007.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Excel 2003 Classic Menu in Excel 2007-2010
    By Excel Fox in forum Classic Menu
    Replies: 7
    Last Post: 09-10-2014, 10:29 PM
  2. Excel 2007 - Freeze Pane without lines
    By irshath in forum Excel Help
    Replies: 1
    Last Post: 02-23-2013, 11:27 PM
  3. Replies: 3
    Last Post: 12-20-2012, 11:10 AM
  4. Amount to Words [EXCEL 2007]
    By msiyab in forum Excel Help
    Replies: 7
    Last Post: 06-10-2012, 03:14 PM
  5. Excel 2003 Classic Menu for 2007-10
    By Admin in forum Greetings and Inception
    Replies: 0
    Last Post: 09-09-2011, 11:51 PM

Posting Permissions

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