Search results for query: *

it's a good start. eanough to allow me to cusotmize it to my specific need thanks again

Thanks mikrom It works great

Wow, Thank you all for your responses I'll try the VBA code suggested

you do understand that your solution is the trivial solution to the problem I stated, right? It's not quite what I was looking for

no business requirement. it's just a problem that I had before and can't stop trying to get an answer to it

Thanks, but, as I mentioned before, I need a script where the NUMBER OF Variables can be a variable ITSELF In your code, there are 3 nested loops. If another case requires 10 variable, I need to rewrite the code to accomodate 10 nested loops. No big deal but, it limites the generality of the...

Here is a more detailed presentation of the question: I have 3 variables A,B,C which can have repectively 6,4 and 3 possible values. I need to create SETS of [A B C] that cover all the possible combinations of A, B and C values. All this in VBA where the input is the NUMBER of VARIABLES (here...

Hello, I have the following Table Name Min Max Nvals A -5 6.7 6 B -10 23 4 C 2 15 3 I am looking for a code that generates all the sets of [A B C] that include all the possible variatiosn as defined in the Table The cath is that the code has to be able to cope with an apriori unknown number...

Hello, I am trying to paste a picture into an open powerpoint slide using VBSCRIPT. I need to find the latest slide an paste it there I have this code which fails on the Activewindow.Selection line. Also the ns line does not work Help would be appreciated Thank you Dim oPPS Dim studio Dim...

Thank you. fixed it

Hello, I have this script and the LastColumn and LastRow lines do not work. Any suggestions? Thank you Set objExcel = CreateObject("Excel.Application") strExcelPath="C:\TMP\TEST.XLSX" objExcel.Workbooks.Open strExcelPath objExcel.Visible = True Set objSheet =...

thanks

yes, I have a word version of a book in Russian and I would like to translate it in English

I would like to translate a section of a word document using VBA. Is this possible? Can anybody help with a source code sample? Thank you

There you go!

Thank you. Works great!

Hello, I have an excel file with many macros so I sometimes have to spend too much time finding it. I was able to create a list of the modules on a sheet. Next, I would like to create hyperlinks, so that when I click (or double click) on the cell, it would bring me to the module in the Visual...

Oops, sorry, I fixed a typo and now it works. All set, Thank you

I was happy too soon I added the line xlUp = -4162 and the LastRow line still gives me an error: Invalid or unqualified reference

Great, Thank you all