![]() |
Plotting Rows that have values
Ok, that title might not describe it right, here goes: So in one cell i have a Total Drawings calculations, that counts ho many total drawings are listed in the spreadsheet. Now if there are under 20, then i just need to print sheet 1, if ther are 20-40 then i need to print 1st and 2nd sheet, and if there are mor than 40, i need to print all sheets. How do I write that in VBA? The "If" is what's bugging me, cause i come from Lisp programming fo Cad and it's just not making much sense to me. Please help. Thanks, Viktor -- Vikxce ----------------------------------------------------------------------- Vikxcel's Profile: http://www.excelforum.com/member.php...fo&userid=1860 View this thread: http://www.excelforum.com/showthread.php?threadid=47772 |
All times are GMT +1. The time now is 05:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com