Results 1 to 3 of 3

error in Worksheet_Change with merged cells

Threaded View

  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

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