I need to select a range and skip over the hidden columns

I have below a code that is selecting from A11 down as far as there is data and across a certain number of columns then sets a print area.

Currently the columns go A, B, JW, JX, JY, JZ, KA, KB as C through to JV are hidden. I have tried to offset the columns by 7 to see if it will select A-KB but it is selecting cells that are hidden and only selecting A-G. I need it to go past the hidden columns. Here is the code:

Please Login or Register  to view this content.

Could I also get a code to go from A10 and move over to KB and create a range from there e.g. KB-KJ and last row from there?


Any help appreciated.

For a range you can use SpecialCells which has a visible cells property. Note: Your above code can be condensed to 1 line.

Please Login or Register  to view this content.

This doesn't seem to be doing anything.

Its not showing any selections or print area. Please note the width of the data will always vary so column KB can't be hard coded in, hence the reason to create a range from A11 to '7' columns over (the excess data will always be hidden to create only 7 columns). Forget the print area for the mean time, I can code that later.

Columns JW and KB can't be hard coded as the data will vary in width over time

That will also change. JW currently holds a 'total' column calculating formulas from the hidden columns. As more columns of formulas are added, the length of columns will get greater but they will always be hidden to show the 'total' column. It will always be the 3rd column along with the next 4 being other information needed on the end. So 7 columns altogether.

Maybe to make things easier: (You can set the print range to it by removing the select and adding like above posts)

Please Login or Register  to view this content.

Leith, This is exactly it but only for 7 columns

Originally Posted by stnkynts

Maybe to make things easier: (You can set the print range to it by removing the select and adding like above posts)

Please Login or Register  to view this content.

Please, it can't have any Hardcoded Columns other than Column A