Jump to content

Search the Community

Showing results for tags 'non-empty'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements and Site News
    • Administration
  • AutoIt v3
    • AutoIt Help and Support
    • AutoIt Technical Discussion
    • AutoIt Example Scripts
  • Scripting and Development
    • Developer General Discussion
    • Language Specific Discussion
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Categories

  • AutoIt Team
    • Beta
    • MVP
  • AutoIt
    • Automation
    • Databases and web connections
    • Data compression
    • Encryption and hash
    • Games
    • GUI Additions
    • Hardware
    • Information gathering
    • Internet protocol suite
    • Maths
    • Media
    • PDF
    • Security
    • Social Media and other Website API
    • Windows
  • Scripting and Development
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Location


WWW


Interests

Found 1 result

  1. I searched around for the best way to this and am still a bit lost. I am trying to find the last non-empty cell in a column in Excel. In the past, there was a function _ExcelSheetUsedRangeGet($oExcel, $vSheet) in >this thread. However, much has changed since then and when I downloaded it I could not find that function to see how it worked. Google found this site for me which offered a couple of promising looking approaches: They are in VBA. I usually can convert VBA but I am not 100% on these. The first approach looks a lot like it should convert easily to _Excel_RangeFind but I am not familiar enough with all the parameters. I understand the operators referenced in the help file but I did not see a lot of info on XLFindLookIn and not sure what to do with .Row. I am also not sure if these are the best approaches? Any guidance on the best way to do this would be much appreciated. If this is already part of _Excel_RangeFind I could use an example. Any help would be greatly appreciated. JFish
×
×
  • Create New...