46 coaches online • Server time: 14:06
* * * Did you know? The best passer is Cherrystone Hotpack with 656 completions.
Recent Forum Topics  Blood Bowl 2024 Edit... | RNG speculations | SWL Season CI |
2014-08-12 13:07:30
10 votes, rating 2.5
10 votes, rating 2.5
Excel doing my head in...
Not to clog up the site with nonsense, so I won't put all the details here, but...
I'm working in VBA, I've hit a wall and need some help controlling page break locations. Internet searches and forums are not helping. I figure this is the most computer-literate community I am a part of, so anyone who has some skill in VBA for Excel and feels helpful, please PM me! Along with my undying gratitude, I will make a fumbbl donation if my problem gets solved!
Cheers folks,
cthol
I'm working in VBA, I've hit a wall and need some help controlling page break locations. Internet searches and forums are not helping. I figure this is the most computer-literate community I am a part of, so anyone who has some skill in VBA for Excel and feels helpful, please PM me! Along with my undying gratitude, I will make a fumbbl donation if my problem gets solved!
Cheers folks,
cthol
Comments
Posted by Badoek on 2014-08-12 13:13:32
vba....
*slowly steps away*
*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!
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.
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
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.