+ Reply to Thread
Results 1 to 3 of 3

error in Worksheet_Change with merged cells

  1. #1
    Registered User
    Join Date
    05-19-2010
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    2

    error in Worksheet_Change with merged cells

    My intention is that in certain cells are put certain values and if not for that cell as far as to call attention to put the red background color and font color to black and become the cell of the error ( I try to avoid the MsgBox).
    Worksheet_Change line 2 put it with the intent that if given the delete key or space is the cell with white background and no data.
    So there I was fine, but do try a combo, this X15 combined with Y15 (for a matter of design of the template), I get error 13 Type Mismatch?? I don't know to have!
    I apologize because I am using a translator from spanish, sorry!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-01-2008
    Location
    Cincinnati, OH
    Posts
    150

    Re: error in Worksheet_Change with merged cells

    No Spanish. I'll try to understand.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-19-2010
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: error in Worksheet_Change with merged cells

    Hi Tom, many thanks for your answer, but if I give the backspace key into merged area and say error num. 13 do not match the types and show me the faulty line number 2 of private sub.
    All other terms is correct, space o baksspace in cell not merged non problem, and the setences If done correctly.
    Thanks

+ 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