Results 1 to 3 of 3

Intersect in VBA

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2008
    Posts
    35

    Intersect in VBA

    Hi all

    I have a piece of code that changes the format of a cell using an intersect statement on the range in question. However, if I try and select more than one cell in the range then an error message is returned:

    'Run Time Error 13':
    Type mismatch

    I know that it is caused by selectin multiple cells - is there a way to error handle this so that, when multiple cells are selected, it ignores the intersect statement?

    Thanks

    Matt
    Last edited by mattydalton; 01-30-2009 at 08:15 AM.

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