Search results

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

ok, I have made a book and uploaded. now, from left to right, first sheet contains an example of table that needs sorted. the rest of them are colored as follows: the color of the sheet is the same as the color of the column on which the action "took place". so imagine that instead of one click...

1. It seems I do not know how to use this - since I do not see it in the macro list, I can not put it into a button and it is not a "before double click action" or some sort 2. forgot to mention: when I click one button, the column will remain with only values of "1" and after that I would...

Hello, First of all, I have a table that looks like this: Head1 Head2 Head3 ... 1 1 2 ... 2 1 2 ... 1 1 1 ... ... ... ..... etc. Since I am using this kind of table every single day, I thought that...

simply gorgeous!

The action is already in the title and I know I'm close but got stuck: Dim wsS As Worksheet, wsU As Worksheet Set wsS = Sheets(&#34;sheet1&#34;) Set wsU = Sheets(&#34;non_confid&#34;) Dim col1 As String, col2 As String, i As Long, j As Long Set wsS = ActiveWindow.ActiveSheet col1 = &#34;A&#34...

since I do not have any option to delete this I am posting again I was not paying attention on the change of windows - I have added "ActiveWindow.ActivateNext" and solved it - works like a charm ! Take care everybody and do not stop trying !!!

Hello all, I work with 2010 and I have some team mates. I am always trying to improve and simplify things but then I must make the change to each of my colleagues. Since we all use one file from a shared location, I have tried to put most of the code into the shared file but no luck so far...

wow !!!! this is pure gold !!! I will give the rest of the solution a go (not sure if I'll pull it out) but the background work it does and not showing on the screen is already making a huge time difference, not to mention the eye care !

Hello everybody, Recently at work we have been "upgraded" from XP to Win7 and from MS Office 2003 to MS Office 2010 but, as normal, not all users; this is made gradually since we are many. Myself, I am working with an Excel file daily so I hit a bump: there is a file that stores all that I...

Hello everybody, I am Laurentiu from Romania. At first I hated excel - saw it as a torture for my eyes but in time I have discovered so much that now I can not get enough of it. Almost every day I am learning new and exciting things about this amazing program. Also, for quite some time I am...