Consulting

Results 1 to 4 of 4

Thread: Hello masters of VBA... here I am a newie for VBA with a question - please help

  1. #1
    VBAX Regular
    Joined
    Apr 2016
    Posts
    11
    Location

    Hello masters of VBA... here I am a newie for VBA with a question - please help

    Hello all the masters in VBA, this is my first post to ask question, but this site is not new to me. I have been absorbing knowledge from all your master posts for very long time. I greatly appreciate all your time and hard work to help people like me who know very very little about VBA code. Without your help, our life will be so painful. I really mean it.

    Ok. Here comes with my first question for the form. I "built" a useform for people to fill up some information. The way I designed is that they are able to "merge" data from "sheet2" to a "Master" sheet and then Email the "Master" sheet to via outlook.

    However, it is not working the way I wanted. The error message "Copy method of worksheet class failed" keeps coming up... when I clicked "Debug", the following highlighted - Sheets("Master").Copy
    I tried many solutions via google around and search into this site. None of them is working. So please help me! I really appreciate your time for this.
    I cant really post the code now

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,646
    If you don't post a sample workbook nor its code we can't help.

  3. #3
    VBAX Regular
    Joined
    Apr 2016
    Posts
    11
    Location
    Quote Originally Posted by snb View Post
    If you don't post a sample workbook nor its code we can't help.
    Hello Snb thanks for your reply, I actually tried few times to paste my code in, but failed. Reason being is that I to new to paste code in post. However, I got some help to fix the problem, it was because the sheet was hidden

  4. #4
    VBAX Guru mancubus's Avatar
    Joined
    Dec 2010
    Location
    "Where I lay my head is home" :D
    Posts
    2,644
    my signature explains how to post a code or workbook to the forum.
    PLS DO NOT PM; OPEN A THREAD INSTEAD!!!

    1) Posting Code
    [CODE]PasteYourCodeHere[/CODE]
    (or paste your code, select it, click # button)

    2) Uploading File(s)
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.

    3) Testing the Codes
    always back up your files before testing the codes.

    4) Marking the Thread as Solved
    from Thread Tools (on the top right corner, above the first message)

Posting Permissions

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