I have software that generates an excel sheet of 62 columns and up to 65525 rows.
When in-Fault appears in the Fault column, I select the previous row and the in-Fault row. with two rows selected. Execute the command: "Column diferences" points out the differences that exist. the cells selected as different will change the background color.
Please, please show in text the code that is executed with the report button. My server removes the macros or codes inside the excel file. And try to log me through the cell phone to download the file and do not recognize the password
I am in my work center. When I download the file it is scanned by the security system and removes the errors and codes: and I receive a file with the following name:
I would like to delve into the technique used here. You could indicate some sites where you can see other examples or where they explain this technique.o be honest, I haven't found many developers that use such techniques but in my experience they work well and are easy to maintain.
Daniel taught that Names are actually more correctly Named Formulae and that all Named Formulae are Array Formulaherclau
I am at a bit of a loss to find suitable material. As Guido says, my posts to this site tend to provide examples of the same approach. Hui might be able to point to relevant podcasts by Daniel Ferry who published insightful material when he was active (I remember one that pointed out that Names are simply references to array formulas).
Hi Hui,Daniel taught that Names are actually more correctly Named Formulae and that all Named Formulae are Array Formula
ie: A100 is actually a Named Formula referencing some memory that has a value or formula that you associate to a logical grid position of A100
Daniel went into great lengths in the Excel Hero Academy to expand on that.
The Module on Names was the first module published
You may still be able to enrol in the EHA, but beware that Daniel never did complete the course
Although what he does teach is far and beyond anything else available
The last enrollee that I am aware of was in March 2018, but there maybe more after that
I would look at Peter's example and work through the data flow that you need, see where/how it is handled in Peters modelHi Hui,
I have been looking for examples where the technique used by Peter to solve my question is shown. But without excitement!
Could you direct me to some other link within this forum where this technique was used?
Sub blah() Set Destn = Range("N2") 'Where the first result will go. Set myRng = Range("A1").CurrentRegion For rw = 2 To myRng.Rows.Count If myRng.Cells(rw, "B").Value = "In Fault" Then Set zzz = myRng.Rows(rw - 1).Resize(2).ColumnDifferences(myRng.Cells(rw - 1, 1)) Intersect(Range("A:A,C:F"), Union(zzz.Offset(-rw + 1), zzz)).Copy Destn Set Destn = Destn.Offset(2) End If Next rw Destn.Resize(, 3).EntireColumn.AutoFit End Sub
I have based my search on the Internet, to locate Peter Bartholomew's method, with the following search headlines:I would look at Peter's example and work through the data flow that you need, see where/how it is handled in Peters model
There are times where Names don't appear as simple as maybe you think it should be
But the logic of what peter Has setup is flexible and extensible in that it allows you to add new names as the data grows