Goto Bookmark

[lscheffler]

Hi,

I do not understand how to gather the Cell coordinates of a bookmark / named range I see I can manipulate it via AddNamedRange / ClearNamedRange.
My problem is that I have XLSX with custom defined headers where the location of (data) column header und start of data is defined via bookmark and I need to figure out this cell(s).
EXCEL command would be GOTO(cTarget)

So what I look for is something like GetNamedRange

[ggreen86]

Unfortunately, I have not yet implemented a method for what you need. I will add it to the list of methods for future implementation. Greg

…

________________________________ From: Lutz Scheffler ***@***.***> Sent: Friday, May 7, 2021 6:38 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: Subscribed ***@***.***> Subject: [ggreen86/XLSX-Workbook-Class] Goto Bookmark (#44) Hi, I do not understand how to gather the Cell coordinates of a bookmark / named range I see I can manipulate it via AddNamedRange / ClearNamedRange. My problem is that I have XLSX with custom defined headers where the location of (data) column header und start of data is defined via bookmark and I need to figure out this cell(s). EXCEL command would be GOTO(cTarget) So what I look for is something like GetNamedRange — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#44>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AGWB33IRWGUZY2JIZAWJQ2TTMO7J5ANCNFSM44JQHCQA>.

[ggreen86]

It is now included in the latest beta version as GetNamedRange(). It turned out easy to implement so I just now added it.

[lscheffler]

That's great news!
Thankyou!