Ask Your Question

rk874's profile - activity

2020-03-21 16:20:37 +0200 received badge  Famous Question (source)
2020-01-22 21:09:03 +0200 received badge  Popular Question (source)
2020-01-22 21:09:03 +0200 received badge  Notable Question (source)
2019-12-12 01:53:11 +0200 marked best answer How to hide a range of rows/columns in a macro

Hi, I have to assign a macro to a button which hides/shows a specific number of rows and columns having a specific index. I insert some buttons in the sheet and theseones have to work like navigation buttons through that sheet.

i.e. I have to jump to a table located on "U230:AF241". The data in the sheet is in the range "A1:ED600" (I mean thoseones are the cells I'm working on). Then it means the macro has to hide all the rows in the ranges "0 to 228", "241 to 599" and all the columns in the ranges "A:T", "AG:ED". Whilst it has to make visible all the rows in the range "229 to 240" and all the columns in the range "U:AF".

I know how to hide/unhide single rows/columns but not ranges. I'm a novice to Basic language so if it's possible for you to write here the code for this macro I'd appreciate it a lot.

Thanks in advance.

2019-12-12 01:53:11 +0200 received badge  Scholar (source)