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

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

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

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

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("sheet1") Set wsU = Sheets("non_confid") Dim col1 As String, col2 As String, i As Long, j As Long Set wsS = ActiveWindow.ActiveSheet col1 = "A&#34...

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

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