Hi Luc, What you describe is what I am looking to do, but the order of the matching cells matters. Cell A1 of the range has to be C1 etc... :)

Hi Walt, I think the 3rd is more of what I require. I am formatting reports of a system that dumps in ASCII format, and it places several reports sequentially on one text file. I figured to isolate these reports the best option is to upload into excel and search for the cells that contain the header fields and thus know where each report begins as the report offers no other fields/tags that indicate report start and end. Thus I want to iterate and find all ranges where cell 1 in the range contains value 1, cell 2 contains value 2, cell 3 contains value 3 etc thus indicating where each report begins. A bit messy but seems to be the only way out Regards

modified on Wednesday, January 12, 2011 1:32 AM

Hi, Is there a VBA technique to search for existence of a range of cells containing certain values and if such range(s) exists severally in a worksheet return an array of these ranges or at least their coordinates? Regards, Cyril

- I have an application that is developed using VBA for automating excel spreadsheets to create and accounting system. Is it advisable to migrate the code to VB.NET going foward, e.g. for consideration of continuity will VBA continue to be as is, backward compatible or is vb.net going to be language of choice with applications?

Hi am a LAMP developer and our team are about to embark on a version 2 of a web based application, with an upgrade of client tier to AJAX. For client-server communication we have narrowed down the options to XML and JSON was wondering what are the benefits and drawbacks of both. Right now am leaning towards JSON? Regards

www.herehost.com :-D

Hi I think you should do a documentation for the initial development project and update with regular changelogs afterwards. Perhaps you wouldn't need to go as deep as u do in systems dev but it depends on the functionality of the website as they are nowadays applications in their own rite.