Solved

Problem with DO Wend Loop

Posted on 2013-12-17
1
130 Views
Last Modified: 2013-12-19
Hi Guys, can you tell me why my code is populating the cells (i,18) & Cells(i,20) with "VALUE#"? I enclose my attachment:


ElseIf Cells(i, 6).Value = "ANCOVBONDM" Then
Cells(i, 18).Value = "-832191"
Cells(i, 20).Value = "0.00"
Cells(i, 23).Value = "0.00"
DummyRec9.xlsm
0
Comment
Question by:Justincut
[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
1 Comment
 
LVL 47

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 39725312
The columns that are "VALUE#" are S and U which in Cells() is 19 and 21, not 18 and 20, so the code you show doesn't apply (at least not how it is written).
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question