View Single Post
 
Old 12-23-2015, 01:40 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 821
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

If I follow your description, try putting
Code:
sht.range("I80").value=Sheet1.Range(whatever).value
right ahead of
Code:
sht.PrintOut
Reply With Quote