Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ExcelSheet.Find using regex
#1
Is possible?
#2
Excel.Find uses Excel's function Range.Find. I don't think that there is an Excel function that supports regex. I would use CellsToArray and for for.
#3
Can this help?

http://stackoverflow.com/questions/2254 ... -and-loops

http://srcedit.pekori.jp/tool/excelre_e.html
#4
I think easier is with CellsToArray and for for. Why to create Excel macros and learn VBScript regular expressions?


Forum Jump:


Users browsing this thread: 1 Guest(s)