I have one Excel problems, First is I have in A1 one date and now i Want to make Macro when i press to the button to find the next same (date) cell and from that cell to hide everything until Column C.
Pendenzenliste1.xlsm
Thank you very much
I have one Excel problems, First is I have in A1 one date and now i Want to make Macro when i press to the button to find the next same (date) cell and from that cell to hide everything until Column C.
Pendenzenliste1.xlsm
Thank you very much
Last edited by Anto_BT; 07-11-2012 at 01:47 AM.
Hello here is attachment of the file if someone knows it will be good.
Attachment 166796
Any help..............?
Can someone help me?
????????????????????????????????
Hi Anto_BT,
I had to write a function to change the column number into alpha notation because, for some reason the hide wouldn't work with numeric notation - anyway here's both the function and the hider.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by xladept; 07-10-2012 at 01:13 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
It is working just with the second.
PERFECT
Thank you very much
You're welcome!
The GetAlpha function is incorrect please replace with:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks