I have made a macro to print a range in Excel.  All it does is print a few 
lines and dots at the top


Range("D4:G11").Select
    ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)"


Is there another way of printing that range as a speadsheet or modifying the 
above macro to print the range in a viewable form.

Try

Range("D4:G11").PrintOut  Copies:=1 

-- 
Jacob


"Philosophaie" wrote:

> I have made a macro to print a range in Excel.  All it does is print a few 
> lines and dots at the top
> 
> 
> Range("D4:G11").Select
>     ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)"
> 
> 
> Is there another way of printing that range as a speadsheet or modifying the 
> above macro to print the range in a viewable form.