I'm not a programmer and do not know Visual Basic, but hoping someone can help with a macro question. Below is code from the macro that inserts a page break, but I would like it to reference the cell content, not the cell. The reason is that the cell most likely will change often.
How can this code be modified to make this work?
Please Login or Register to view this content.
Last edited by BBoydAnchor; 12-16-2011 at 09:52 AM. Reason: Add the CODE block, change title and add more color for clarity
Try the following macro, which will insert horizontal page breaks for the active sheet...
Please Login or Register to view this content.
Thank you Domenic. That worked exactly how I wanted it to. As I mentioned, I'm not a programmer, but trying to learn. I just took my first class in C++ and will be taking more programming classes next semester. VBA classes will either be next summer or fall as I have to take another C++ class as a prereq for VBA.
Anyway, thank you very much.
You're very welcome! Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks