Top "Vba" questions

This should work according to another stack overflow post but its not: Dim arrWsNames As String() = {"Value1", "Value2"} Can anyone …

I wrote a macro as an add-in, and I need to get the path of the current worksheet on which …

I would like to loop through the files of a directory using vba in Excel 2010. In the loop, I will …

I am trying to add an Excel sheet named "Temp" at the end of all existing sheets, but this code …

In the VBA editor of Office (ALT + F11), how do you comment or uncomment a block of code?

I want to select the formatted range of an Excel sheet. To define the last and first row I use …

I need to convert a string, obtained from excel, in VBA to an interger. To do so I'm using CInt() …

Via VBA how can I check if a cell is empty from another with specific information? For example: If A:…

I have a problem with summing cells in vba. I need to use Cells(a,b): Range("A1").function="=SUM(…

How do I express the condition "if value is not empty" in the VBA language? Is it something like this? "…