Hiding columns - out of memory

[megabolic]

Hi all,

i'm having trouble with this simple piece of code ...
What it does : it looks in a row what the last cell is with a value, then it goes in a loop (max untill that last cell) where the year factor of a date will be compared to a value you filled in on the userform. I want it to remember the first column it encounters with that year. All the columns which came before have to be hidden.

But, selecting the cell and looking at the year always gives me an "out of memory" fault. So i can't even check if the rest of the code works too

Can you guys help me out ???

Thanks in advance,

megabolic

[kev_]

This gives you a simple method to hide columns based on the active cell.
It looks at row 6 of the column of the active cell to determine the year and then, starting at column H finds the first incidence of that year.

This is easily adapted. The trick is the little loop and what is fed into it as the variable "myyear"
The value of variable "col" when the loop has finished minus 1, is the last column number of the previous year

Please Login or Register  to view this content.

[megabolic]

thanks for all the help !

[kev_]

You are welcome
Thanks for the reps