Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
PRINTING BY SELECTING DATES FROM SPECIFIC ROWS
Name:
SHAWN BULL
Email (spam proof):
Email the originator of this post
Date:
Wednesday, March 01, 2006
Hits:
60
Discussion (Terms and Conditions):
Does anyone know of specific vba code that can be used in a macro that will enable one to print dates not exceeding 31 / 30 days. The background is this. I have 2 columns with weekdays in one column, day dates in the other. I substitute these dates into a spreadsheet that captures stats and print them out using a macro recorded (tediously) by placing dates from row one into correct cells, then print, repeat with row 2, print etc up to row 26. The problem is that on some months from row 23 you get dates like 33rd March etc. I would like to know if there is some way that one can use a conditional statement that will only print up to valid dates. I'm not a VBA programmer so to put the problem in routine format this is what I'm looking for. For x = 1 to 25 goto cell b1 if cell b1 > last day of month then end else put cell a1 into cell d1 put cell b1 into cell e1 print spreadsheet next x {where next x will select cell b2 and repeat up to b25 then end} end The bonus would be if I could build in public holidays that fall on weekdays, not to print.

Sponsored by the best FTP application on the internet: