Solved

Do Loop problem.

Posted on 2013-12-12
3
164 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
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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