Very basic question - somehow can't solve this :-( Can you please help me to set the number format on a cell to be a combination of a string variable and this n
I initially asked this question How to loop through a specific row of a 2-dimensional Array? and @FaneDuru was kind enough to supply a solution but now I am hop
I have a VBA macro that allows me to issue drawings - as part of this, it allows properties of the model to be changed, issue, date of issue etc. The idea is ju
I need your support to re-arrange an excel sheet, listing all values in columns to be in new raws. As is: enter image description here To be: enter image descri
I've used various guides, documentations and tutorials to create a custom formula. Basically the formula takes two parameters ItemID and DateV. =DP(ItemID,DateV
I have a spreadsheet using two sort routines: Sub Sort_Date_From_To() Range("A3:Q10000").Sort Key1:=Range("C3"), Order1:=xlAscending, Key2:=Range("F3"),
I installed "Power Query" in Excel 2013. Works fine. However it doesn't support VBA. No code is generated when I try to make a macro with the macro recorder. Wh
I have following code Sub Example() Dim l1 As Integer Dim l2 As Integer Dim l3 As Integer For l3 = 1 To 2 For l1 = 1 To 2
I have received a request to fill in date based on specific status chosen (cell value) in a column representing that status. For example if I choose a Status "E
I have duplicates lines on each cell, these lines are merely URL address separated by vbLf. I need to remove duplicate lines, but only per each cell on the col
I have an ActiveX Textbox on an Excel worksheet. I need to move this textbox around and change its visibility using VBA frequently as you interact with the prog
I encounter a problem with Microsoft visual basic that variable values in Hebrew are converting to gibberish. Please see the attach picture The computer locale
I tried to find old posts related to this same issue but couldn't find a solution which would fit to my code. I'm trying to add checkboxes to Excel sheet every
I am trying to find out if there is a way to group rows in a table within a database based on the values from multiple columns. My specific problem is that I am
I'm wanting to automate a few things in Excel, problem is I am definitely not a programmer / scripter so this is all foreign to me. I have a list that changes i
I would like to change the response to a meeting, that I have accepted, to tentative and send text like "I'm sorry, but I cannot attend.". Online, I found solut
Dim path as String dim a as string dim b as string a = range("A4") // variable name in cell b = range("A106") // variable of other name in cell Workbooks.Open
I have a procedure called TableNumberSequence that adds a table row, pauses for a second and then adds another. It does this up until what's specified in the co
This is what I want to achieve with the code further down: If I use the RETURN key, the cell right next to the current cell should be selected, rather than the
I am trying to find a specific subject in a shared outlook calendar on a specific date. The subject, the date and the shared calendar is passed as arguments. Th