Hello:
I need a Vb macro to do print setup.
I have lots of daily data from column A thru column J.
Each day data range upto 45 rows.
So basically
1st day data will have range A1:J445
2nd Day data will have range A46:J90
3rd Day data will have range A91:J135
and so on until day 31st.
Need a macro so to configure Page setup so that each day data is printed on one page.
Let me know if you have any questions.
Thanks.
Riz
I have a querstion : Have you tried doing it or recording a macro doing it, then changing it? Or do you want someone to do it for you?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hello:
No i have not tried.
I was seeing if VB Code will make it consistant to display all pages for month.
Would aprreciate all the help i could get.
Thanks
Riz
Try then, pretty much everyone in here started by recording what they do, then picking the code apart. Much cheaper than books
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks