How to find last column in excel

[r_vdbraak]

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

[Chanty4u]

Hi,

did you check this?

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

[r_vdbraak]

Chanty4u,

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

[Brett_Bleess]

@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