View Single Post
 
Old 06-03-2013, 03:34 AM
-=bb=- -=bb=- is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: May 2013
Posts: 8
-=bb=- is on a distinguished road
Default

Quote:
Originally Posted by JohnWilson View Post
Depends exactly what you mean but maybe:

objWbk.worksheets("Exec Summary").UsedRange.Copy
Hi John,

Thank you very much for taking the time to reply - sorry for the lateness of my reply I have been out of the office for a few days on personal leave.

Unfortunately using the method that you mention above, I get an Object Required Error.

My code looks like this currently

Code:
 
With objWbk.worksheets("Surveyed Area by Area")
        Range("D14").Activate
        UsedRange.Copy
EndWith
Application.ActiveWindow.View.PasteSpecial (ppPasteBitmap)
I am sure it is something particularly numpty-ish that I'm doing!

Many thanks
Reply With Quote