Consulting

Results 1 to 5 of 5

Thread: Type Mismatch Error when Setting WorkSheets

  1. #1

    Type Mismatch Error when Setting WorkSheets

    I found the typo how do i delete this thread?
    Last edited by BoaredGamer; 01-02-2022 at 11:28 PM. Reason: trying to find the delete button in edit/delete

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,058
    Location
    Since we don't yet know your "Typo"... its very difficult to assist you. Then again if you felt the need to post a thread to this forum, and you suddenly felt the need to delete the thread, you simply could have asked a moderator or Admin to delete the thread, but no.... you screwed up. I for one think maybe I'll leave this thread up for all to see.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,726
    Location
    Quote Originally Posted by BoaredGamer View Post
    I found the typo how do i delete this thread?
    Or you can just edit the original post by adding something like

    Edit: Never mind -- I found my mistake. I needed to ....... " and marking it [SOLVED] by using Thread Tools on the right hand side above the first post

    That way your solution might help someone else who searches the forums for a similar problem
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  4. #4
    I see thanks, sorry new to the forum, joined yesterday, not sure what the proper etiquette is here, just thought that probably deleting the post was the best way to go considering the typo was literally me mistaking "worksheets" for "worksheet" when declaring variables, that's why i tried to delete the post, i though i could considering the edit button shows "edit/delete" when hovering over it, didn't know you needed to contact and admin to delete the post

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,726
    Location
    No problem

    There's a link to our FAQs in my signature, as well as some other things that frequently come up

    Hang out here, ask questions, answer some posts, and you'll be right at home in no time
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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