Recent content by l_mirica

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...

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...

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 =...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ! :(

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...