Thread
:
Trying to find a macro that will copy a cell and paste that value to a specific sheet
View Single Post
12-23-2015, 01:40 PM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
If I follow your description, try putting
Code:
sht.range("I80").value=Sheet1.Range(whatever).value
right ahead of
Code:
sht.PrintOut
NoSparks
View Public Profile
Find all posts by NoSparks