Office Excel Macro - How to hide columns or rows

[Michael Rachimi]

I have a spreadsheet with some columns i want to hide. When I limit the columns it does not actually work. It takes all the columns. Is there some way to enforce the Column and Rows to limit the macro view. 

[Sireesha Dugginapeddi [Appfire] · Accepted solution]

Hi @Michael Rachimi,

Yes, the Last Row and Last Column parameters do not work as expected in the Office Excel macro. There is an open ticket with Atlassian for the same, where you might want to add your vote - CONFSERVER-31741.

You can use the Boswift Excel for Confluence macro instead to hide the required columns. Look for the Columns to Show parameter in Excel Macro.

Hope this helps!

Thanks

Sireesha

[Michael Rachimi]

Thanks. We are going to review your suggestion.