Posted by Badoek on 2014-08-12 13:13:32
vba....
*slowly steps away*
Posted by Chainsaw on 2014-08-12 13:19:37
www.stackoverflow.com
Posted by Sp00keh on 2014-08-12 15:05:46
www.mrexcel.com
Posted by the.tok on 2014-08-12 15:06:19
I know that feel... VBA can be a *beach* sometimes.
I do use VBA for excel quite a lot, but for very basic things, like post-formatting SAP/ABAP reports, so I doubt I'll know more than you, since I never had to do anything concerning page break locations :-/
If you give more details I *might* be able to help, but if you're already familiar with VBA and are looking for something really advanced...
If nobody with better knowledge stands up, I might as well try!
Posted by cthol on 2014-08-12 15:33:06
I suspect it's worse than that: I am not very familiar with VBA, but I am looking for something relatively advanced. I have some PM stuff going on, hopefully it will work out :)
Posted by CroixFer on 2014-08-12 15:44:05
I used to design macros for heavy data handling in excel. After programing, it would present VBA for smoothing. But main code was auto-produced by the. VBA itself.
My suggestion: do what you want in a macro And check the piece of code generated. May be you can work from there...
Hope it helps.
Posted by Duder on 2014-08-12 16:51:26
I used to do a lot of VBA programming in excel but have been away from it for several years now. When I needed detailed specifics answered I usually found Excel (insert version #) Power Programming by John Walkenbach to be a great resource.
Posted by pythrr on 2014-08-12 17:52:52
I am so happy that I understand none of this, and do a job that does not involve these things.
Posted by Lorebass on 2014-08-12 18:40:49
+1 to MrExcel, stack overflow is only good if you want a simple question that requires a one line response expanded into a horrible 500x larger complicated code(dick) measuring contest.
I have done VBA for things and likely cant help you much anywho... cause I dislike programming! wooooo
Posted by sann0638 on 2014-08-12 19:28:51
Another +1 to MrExcel, spent many a happy hour on there in my previous job when I should have been working.