vba

An array of full names is set. You need to determine the gender of each person by the last vowel letter. Here is the code, it ... If gls = g Then Cells(a, 3) = "жен" Else Cells(a, 3) = "муж" End If Next a End Sub How to fix it?

Please tell me how for Excel VBA should look like a regular expression to select from the text of the form 12345.12345TEXT123 ... (text) But it seems that I do not understand anything in regular expressions at all : (because it finds only the full string

There is a macro that gets values from a closed book (formally, it opens it using Workbooks.open(), disables events/alerts Ap ... open the second instance of this book, read the necessary data and close it, so as not to touch the instances opened before?

Macros written in VBA Excel 2010 (in the file nameFile) using Application.Windows(nameFile).Activate periodically stop workin ... w sizes of the XLMAIN, EXCEL7 classes, so as not to execute the command once again: Application.WindowState = xlMaximized ?

There is a task to make a variable whose value is text. You need to print this text in another book (file), and then use it t ... le, and not just the assignment of a cell that is equal to another cell, I think you have already understood. Please help me.

How do I get the return value of a function? I.e. declared a function: Public Function GetPi() As Double Return 4.0 * Mat ... Complains about the Return string and writes Syntax error. And how to correctly (by syntax) take the value of the function.

Sub CommandButton1_Click() Dim lCol As Long Dim LR As Long 'до последнеи строки и столбца LR = Cells(Rows.Cou ... у надо штобы формула протянулась автоматищески 'то есть "J10","K10"...заменить в переменную,никак не получяетца End Sub

In the Excel file, there is a VB script that worked properly and still works on all other computers. But I recently reinstall ... tand how do I find out which class to register? I ask for help, if someone solved such a problem, please give me some advice.

You need to add up the matrices using VBA Excel. For multiplication, there is a function of the MMult sheet, for addition, I ... will slow down calculations very much. On the addition of a matrix of type C=A+B, the interpreter swears-incompatible types.

Hello, we decided not to "twist" a lot and perform the task of filling the site in such a way as-in excel via vba to write a ... ТА СТРОЧКА НЕ РАБОТАЕТ!!! End Sub Why doesn't the macro fill in the form with the name "description"? Thanks for the answer!

You need to break all absolutely references in the entire book with a python script, but so that the values remain. You can use a macro. How to implement it?

Take, for example, nine cells, each containing one word or expression. The cells can also be empty! In the tenth cell, all wo ... м, город, кольцо и дети If only one cell in the input contains a word or expression, the output should be, for example: город

The program works perfectly with .xls , but not with .xml Task: find the PIE files with the extension .xml and convert the e ... nRow = nRow + 1 loop wb.Sheets(1).Rows(nRow & ":" & nRow+20000).Delete

Please tell me how to determine the file name. There is an Access file. You need to get its own name when you open it. In wor ... thods(do not work in the access), but I did not find such a thing in the access. Maybe someone has encountered it. Thank you

There are several links in the table, but when I copy what is in the cells, I get the values: 38014960 38014980 38014740 38015080 How do I get the links?

Let's take a number between 1 and 1 000 000 000 000 000, where, for example, the class of digits of the number that we will c ... ould get this: Fffttt Using the example of the number 225,485: Ffffft Using the example of the number 200,000: Ffffft , etc.

Assigning a cell from the "cell" variable to the "prevCellValue" variable" In the variable "prevCellValue" the value remains, but not the reference to the cell as it was in "cell" How do I leave the variable types the same when assigning?

Is it possible to do something so that when you open a book, two windows with certain sheets open at once? (Is it possible to make a window open on 1\3 of the workspace) mb VBA, macros will somehow help?

Help solve the problem - you need to pause using VBA in Excel so that during it you can enter data into the cells - after the ... e PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems Sleep 3000 'delay in milliseconds

Task: convert xml to xls Problem: the error "line 2, character 11, error: "The end of the construction is assumed", code: 800 ... pplication") Set xlBook = xlApp.Workbooks.OpenXML(xmlFile, 2) xlBook.SaveAs xlsFile, 6 xlBook.Close False xlApp.Quit End Sub