ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Plotting Rows that have values (https://www.excelbanter.com/excel-programming/343303-plotting-rows-have-values.html)

Vikxcel[_3_]

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