Results 1 to 28 of 28

Code with Range(Cells()) doesn't work. Why?

Threaded View

seigna Code with Range(Cells())... 04-21-2013, 05:32 AM
Norie This, plaga =... 04-21-2013, 05:46 AM
mojo249 Re: Code with Range(Cells())... 04-21-2013, 05:50 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 05:52 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 06:10 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 06:13 AM
mojo249 Re: Code with Range(Cells())... 04-21-2013, 06:21 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 06:53 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 06:47 AM
mojo249 Re: Code with Range(Cells())... 04-21-2013, 06:57 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 07:07 AM
Norie Where do you get the error? ... 04-21-2013, 07:47 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 07:53 AM
mojo249 Re: Code with Range(Cells())... 04-21-2013, 07:49 AM
mojo249 Re: Code with Range(Cells())... 04-21-2013, 08:04 AM
Norie How would using Cells make it... 04-21-2013, 08:05 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 08:05 AM
Norie Re: Code with Range(Cells())... 04-21-2013, 08:13 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 08:13 AM
Norie Re: Code with Range(Cells())... 04-21-2013, 08:26 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 10:51 AM
Norie Re: Code with Range(Cells())... 04-21-2013, 10:59 AM
seigna Re: Code with Range(Cells())... 04-21-2013, 01:38 PM
Norie Re: Code with Range(Cells())... 04-21-2013, 01:58 PM
seigna Re: Code with Range(Cells())... 04-21-2013, 02:21 PM
Norie Re: Code with Range(Cells())... 04-21-2013, 02:28 PM
seigna Re: Code with Range(Cells())... 04-21-2013, 03:36 PM
Norie Re: Code with Range(Cells())... 04-21-2013, 04:04 PM
  1. #1
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Unhappy Code with Range(Cells()) doesn't work. Why?

    I am working on the following code, and instead of selecting a range by naming the cells exactly, I changed to a more general way using Cells( , )
    However, now, I get a message saying "Type mismatch" but I don't really see what's wrong given that I have only updated the formula to a more general one...

    Option Explicit
    Option Base 1



    Sub dort9()
    
        Dim cMin As Double
        Dim cMax As Double
        Dim lDer As Long
        Dim NoIntervals As Long
        Dim plaga() As Variant
        Dim I As Long
        Dim J As Long
        
        
        NoIntervals = 5
        ReDim Preserve plaga(14)
    
        plaga = Worksheets("Sheet2").Range(Cells(1, 1), Cells(1, 14)).Value
       
    
        Call tri1(plaga)
    
        cMin = WorksheetFunction.Min(plaga)
        cMax = WorksheetFunction.Max(plaga)
    
        Dim longInter As Double
        longInter = (cMax - cMin) / NoIntervals
    
        ReDim plaga2(1 To NoIntervals) As Long
       ReDim arrintervals(1 To NoIntervals)
        
        Dim pla As Variant
        Dim lCom As Long
        Dim res As Variant
        
        For I = 1 To NoIntervals
            arrintervals(I) = cMax - ((I - 1) * longInter)
        Next I
        
        For Each pla In plaga
            res = Application.Match(pla, arrintervals, -1)
            plaga2(res) = plaga2(res) + 1
        Next pla
        
        For J = NoIntervals To 1 Step -1
            Worksheets("Sheet2").Range(Cells(2, 1)).Offset(NoIntervals - J) = arrintervals(J)
            Worksheets("Sheet2").Range(Cells(3, 1)).Offset(NoIntervals - J) = plaga2(J)
        Next J
            
    End Sub
    Last edited by seigna; 04-21-2013 at 06:14 AM. Reason: To make it easier and to provide data

Thread Information

Users Browsing this Thread

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

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