sample macro for printing by selection
Dear all,
I need to produce a report from an Excel file with below requirement (just an example) : in sheet 1, 2 & 3, if column B = "1" & column C = "Y", then print that row and the header row for each page as well. If you have a sample of this kind of macro, please provide. Since I don't have any experience in writing Excel macro, any good reference site? Thanks PL. |
sample macro for printing by selection
Hi, record a macro to perform the desired operation. That should give you a
code snippet, upon which you can improvise. I hope this helps you. "PatLee" wrote: Dear all, I need to produce a report from an Excel file with below requirement (just an example) : in sheet 1, 2 & 3, if column B = "1" & column C = "Y", then print that row and the header row for each page as well. If you have a sample of this kind of macro, please provide. Since I don't have any experience in writing Excel macro, any good reference site? Thanks PL. |
All times are GMT +1. The time now is 01:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com