Solved

error vba

Posted on 2016-08-02

Microsoft Excel

1 solution

50 Views

Last Modified: 2016-08-22

Hi Experts,

PFB my code. I am getting an error on Range(Sheets("simulations").Cells(2, ctr)).Value = Sheets("Model").Range("AP42:AP1041").Value.

Please suggest.

Thanks

Sub loopThrough()
Dim i, j, ctr As Integer
Dim r(0 To 4, 0 To 4) As Long
Dim r2(0 To 4, 0 To 4) As Long

ctr = 1
For i = 0 To 4
    For j = 0 To 4
    Range("Run").Value = ctr
    Calculate
     Src = Sheets("Model").Range("AP42:AP1041").Value
    Range(Sheets("simulations").Cells(2, ctr)).Value = Sheets("Model").Range("AP42:AP1041").Value
    r(i, j) = Range("c").Value
    r2(i, j) = Range("s").Value
    ctr = ctr + 1
    Next j
Next i

End Sub

Open in new window

Comment

Question by:camper12

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 43

Accepted Solution

by:Saqib Husain, Syed

Saqib Husain, Syed earned 500 total points (awarded by participants)

ID: 417399952016-08-02

You are assigning a multiple cell array to a single cell which does not seem right

Meanwhile try
Sheets("simulations").Cells(2, ctr).Value = Sheets("Model").Range("AP42:AP1041").Value

LVL 43

Expert Comment

by:Saqib Husain, Syed

ID: 417641712016-08-21

No follow up by the asker

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Excel - Creating Drop-Down lists that depend on the value of another list(s)

Article by: redrumkev

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…

Microsoft Excel

Ensure Data Integrity and Privacy with VBA

Article by: Josh

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.

Creating an Efficient Dashboard in Excel

Video by: Katie

Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…