+ Reply to Thread
Results 1 to 2 of 2

PasteSpecial Method of Worksheet class failed

  1. #1
    Registered User
    Join Date
    01-14-2012
    Location
    Worthing, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    PasteSpecial Method of Worksheet class failed

    Running a macro on Excel to upload to website, get that error or the error 'Subscript out of range'. I've seen a thread on here before about this, i got sent the file to use and have no experience with macros so i have almost no idea what i am doing. The file worked before on the mac it was used on before. I'm running Windows 7, Excel 2007.
    The part of the macro that gets highlighted when i select debug for the Pastespecial error is

    Postponed
    Last edited by Gitch28; 01-15-2012 at 03:54 PM. Reason: Time issues

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: PasteSpecial Method of Worksheet class failed

    Can you wrap your code in tags, it is against forum rules not to. Go to advance edit and click this # icon.

    No.2, Could you post the full code?
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1