Quote:
Originally Posted by JohnWilson
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