Excel issues

[kawumm3000]

On 5/31/2017 at 4:36 PM, water said:

The following script ignores all "touched" cells in column A:
 

#include <Excel.au3>
; XlDirection enumeration: https://msdn.microsoft.com/en-us/library/office/ff820880.aspxGlobal $oExcel = _Excel_Open()
Global $xlup = -4162
Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookOpen($oExcel, "C:\temp\Test.xlsx")
Global $iRow = $oWorkbook.ActiveSheet.Range("A65536").End($xlup).Row
MsgBox(0, "", $iRow)

 

Hi @water
in my excel file it doesn't work because it counts also all the cells that a somehow formated. Can this also ignores formated cells and only counts cells with data?

thanks

[JLogan3o13]

@kawumm3000 In the future, instead of hijacking a 5 year old thread, please just create your own.

[water]

@kawumm3000

No, a "touched" cell has its content or format modified.

You can get further information from the wiki: https://www.autoitscript.com/wiki/Excel_Range
or from this or similar web pages: http://www.ozgrid.com/VBA/ExcelRanges.htm