• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by l_mirica

  1. L

    QAT icon keep active till next click

    Hello folks, I have recently put "Design Mode" on QAT and noticed that once clicked, it stays "selected" until the Design Mode is deactivated. I figure there must be a way to do the same thing for other macros. For instance, I have a code that allows me to copy the active cell's content but...
  2. L

    combining vba codes

    I know it's been ages since I've started and thank you all for your input. I have managed to achieve all of it in a singe macro by using array. arrays are really powerful but a little more complex anyway, here is the new code: Sub conc_trans() Dim rRange, Re, cell As Range, OutStr As String...
  3. L

    MyArray(a) = WF.substitute(MyArray(a), oldTxtArray(b), newTxtArray(b))

    Hello all, Can somebody make this happen for "case INsensitive" ? ... and some wild cards also ... dim myarray, oldTxtArray, newTxtArray dim a, b as integer MyArray = array("some","random","stuff","This","tExTing","waNtInG") oldTxtArray = array("no","want??","this","text*") newTxtArray =...
  4. L

    combining vba codes

    could you please direct me to some reading material so I could understand (and hopefully apply this method): ar = [{"=", " ", "{",""",""",""""}]
  5. L

    combining vba codes

    sorry for wasting your time. however my thought was to make people come here for various solutions instead of looking for punctual resolve. for me it is way easier to learn by testing and searching and understanding pieces of code. I have a job that does not require any programming but I would...
  6. L

    combining vba codes

    both versions have the same result >=CONCATENATE(TRANSPOSE(trans&","))< in whatever cell I choose. I am uploading a file as an example of what I am trying to pull. It also has the buttons so you could see for yourself what I am talking about. so - the first sheet will be having a table and...
  7. L

    combining vba codes

    yes, I am trying to recalculate but could not find an alternative that works and if I do not move one cell down and then back up - else the result is buggy as for the second part, I am open to suggestions - I do not have a 'static' reference and it would be great if I do not select it again...
  8. L

    combining vba codes

    Hi all, I know there are people like me (noobs) out there in search of crumbs. So, I have made or found one piece of code, and my need evolved ... created or found another piece and so on ... Before I give you my example I would like to invite you all to share your ideas, even if they might...
  9. L

    vba button sort value1, value2 or reset

    Once again I would like to thank you so much for your help ! I have discovered where my first column sorting has the issue - once along the way I have made a poor setting and tried to replicate the whole thing (to see if excel has a problem) looks like it did exactly the same so I went and...
  10. L

    vba button sort value1, value2 or reset

    then leaving =I= declaration to =Integer=, just changed: Select Case I Case Is = 0 .AutoFilter Field:=piCommandButton Case Is = 1 .AutoFilter Field:=piCommandButton, Criteria1:="Yes" Case Is = 2...
  11. L

    vba button sort value1, value2 or reset

    Just wanted to let you know that I've made the required modification and now I (I mean WE) use this new piece. Dim I As String '........................... Case Is = 0 .AutoFilter Field:=piCommandButton Case Is = 1 I = "Yes" ' added...
  12. L

    vba button sort value1, value2 or reset

    pfiu ... finally I've got it to work (I had to modify my book) ;) thank you so much for your help. since i've struggled to "transpose" it into my work, I am starting to understand it. had a bit of struggle cuz instead of 1 and 2 values I had yes and no and since now there are some ppl who...
  13. L

    vba button sort value1, value2 or reset

    simply mind blowing but as I feared ... I still forgot something. that table needs to be dynamic so, if I add or remove data from it - or just change all data (but always keeping the headers) I need it to work. So, it needs a little adjustment - Insert > Table (My table has headers) because now...
  14. L

    vba button sort value1, value2 or reset

    yes :P but control on every column so I just need that piece of code to put in every button over the header, instead of that of the "sort" one cheers! I have a very poor communication skill ! :(
  15. L

    vba button sort value1, value2 or reset

    it can be a 3d value but I am only interested in 2. that was just as an example so that, if I have many filtered columns, I should be able to cycle through one single column once again to check stuff up (or if already filtered N columns and one wrong click - in just a couple more clicks it's all...
Back
Top