Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 4321orso

    VBA-xl: how 2 create objects = moving ranges? Help !

    here is some code lines I wrote. It's a sub that finds the address of the local maximum in a range (same for minimum). You can see it below in a standalone form (does not connect to anything else yet and values and data type I put in are quite arbitrary)...
  2. 4321orso

    VBA-xl: how 2 create objects = moving ranges? Help !

    hi Skip, I am still working on this. Here is an example of what I am looking to achieve. I also wrote some code lines and will post them aferwards. I have an excel spreadsheet and in column 3 I have a data series (time is in column 2, not shown). In Col 4 I have the difference between the...
  3. 4321orso

    VBA-xl: how 2 create objects = moving ranges? Help !

    that sounds more straightforward, I guess the object-way is clumsy in comparison. I'll study the structure bit of my books tonight. Thank you again SkipVought, u r very helpful ! F
  4. 4321orso

    VBA-xl: how 2 create objects = moving ranges? Help !

    hi SkipVought, I will try to clarify what pesudo code and sequencer mean (must be somewhere in the books I have). Are you saying that you think that the solution I outlined (ie creating objects and then putting a progressive number on them) is a promising one ? What do you recommend I...
  5. 4321orso

    VBA-xl: how 2 create objects = moving ranges? Help !

    Hi guys, I am writing (trying to write) a program in VBA (Excel 2003) and I got stuck. I need your help please. HERE IS A DESCRIPTION OF WHAT I WANT TO DO I have an excel range where the upmost cell is initially fixed and the downmost cell moves down as more data arrive. I have something...
  6. 4321orso

    VBA-Excel: make objects of moving ranges ? Help !

    hi HarleyQuinn, thank u for ur reply, I'll post there. F PS: yep, excel 2007 would do
  7. 4321orso

    VBA-Excel: make objects of moving ranges ? Help !

    Hi guys, I am writing (trying to write) a program in VBA (Excel 2003) and I got stuck. I need your help please. HERE IS A DESCRIPTION OF WHAT I WANT TO DO I have an excel range where the upmost cell is initially fixed and the downmost cell moves down as more data arrive. I have something...

Part and Inventory Search

Back
Top