topic Re: How to find last column in excel in QlikView

How to find last column in excel

r_vdbraak — Sat, 16 Nov 2024 17:56:57 GMT

Hi,

I want to make a macro to store qlikview data in an excel sheet.

How can I get the last used Excel column so I can use that number to select the next column.

Thanks for thinking with me.

Richard

Re: How to find last column in excel

Chanty4u — Tue, 20 Oct 2020 13:04:33 GMT

Hi,

did you check this?

https://community.qlik.com/t5/New-to-QlikView/Macro-find-last-column-in-Excel-file/m-p/699684

Re: How to find last column in excel

r_vdbraak — Wed, 21 Oct 2020 09:40:47 GMT

Chanty4u,

Thanks so far. How can I use the next right column.

Re: How to find last column in excel

Brett_Bleess — Wed, 04 Nov 2020 16:26:44 GMT

@r_vdbraak I believe your question is more appropriate to the Microsoft Forums, in particular VBScript area related to Excel etc., that is where the experts are going to be on this one.

Regards,
Brett