Sorry, I cross posted this question on the ExcelForm and Bytes: here are the links
http://www.excelforum.com/excel-prog...es-in-vba.html
http://www.mrexcel.com/forum/showthread.php?t=378477...
billofsoo
Last Activity: Mar 24 '09, 10:57 PM
Joined: Mar 24 '09
Location:
-
VB for Excel
I may be posting in the wrong area but probably someone here can help. I am writing VBA code to do the following:
IF A1 > 50 then print array C1:E1
I have this code and it works.
Sub Test()
If Range("A1") > 50 Then
ActiveSheet.Pag eSetup.PrintAre a = "c1:e7"
ActiveWindow.Se lectedSheets.Pr intOut Copies:=1
End If
Call cler_print
End Sub...
No activity results to display
Leave a comment: