Results 1 to 10 of 10

Type Mismatch when switching from single cell Range value to multiple cell range value

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    Type Mismatch when switching from single cell Range value to multiple cell range value

    Went from a single cell --> Range("B" & r) which was working fine, to multiple cell --> Range("B" & r & ":D" & r) and now getting a type mismatch error. Not sure why... Your help is appreciated!

    Sub Relabel1()
    Dim lastrow As Long, r As Long
    lastrow = Sheets("SummarySheet").Cells(Rows.Count, "E").End(xlUp).Row
            For r = 7 To lastrow
                If Sheets("SummarySheet").Range("B" & r & ":D" & r).Value = "" Then
                    Range("B" & r - 1 & ":D" & r - 1).Copy Destination:=Sheets("SummarySheet").Range("B" & r - 1 & ":D" & r - 1)
            End If
         Next r
    End Sub
    Last edited by Mr_Ekid; 07-17-2015 at 03:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cell = Range("A1") Type mismatch
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 01:58 AM
  2. Type Mismatch error when calculating a set of functions on a multiple range
    By AnnaDana in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2013, 02:27 PM
  3. Replies: 5
    Last Post: 07-27-2010, 10:58 AM
  4. Type mismatch using rnge as Range with Type 8 Input Box
    By STEVE BELL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2005, 01:10 AM
  5. Type mismatch on range name
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2005, 02:05 PM

Tags for this Thread

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