+ Reply to Thread
Results 1 to 30 of 30

line item extractor

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2004
    Posts
    53

    Re: Macro to extract line specific line item from Excel Sheets

    THe script is awesome. I am so glad i am getting help from you. there is a problem though. When i enter accoutn number and press 'OK', it asks me to add workbooks, i search for workbook and then press OK. i get error code 91.


    Runtime error 91

    After Debugging:This section is highlighted in Yellow

       AcctCol = ws.Cells.Find(AcctColStr, After:=ws.Range("A" & Rows.Count), _
                    LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
                    SearchDirection:=xlNext, MatchCase:=False, _
                    SearchFormat:=False).Column
    Last edited by bholabhala; 05-09-2010 at 03:02 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macro to extract line specific line item from Excel Sheets

    Please edit your post to add CODE tags.
    Entia non sunt multiplicanda sine necessitate

+ 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