Solved

Do Loop problem.

Posted on 2013-12-12
3
173 Views
Last Modified: 2013-12-13
Hi Guys, I have a problem with a Do loop problem. If you look in Column "AD" of the attachment, the Macro "Non-Validated" is populating the 4 rows filtered as "Cells(i,30)" . Can someone correct it?
DummyRec7.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
  • 2
3 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39713755
That code doesn't populate those cells at all  (clear them and run the code and you should see) - they don't match any of the criteria.
0
 

Author Comment

by:Justincut
ID: 39713787
Try now
DummyRec7.xlsm
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 39713834
That code doesn't do anything weird either. I think someone pasted the code into the cells by accident. There isn't anything in the code that does that - it doesn't put anything in the cells that start with "Cells(..." currently.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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…
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…

739 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