string variable

I'm trying to get this code to open a file for me: Sub openfile() Dim A As sting Dim B As String A = Application.InputBox("type value of A here:") B = Application.InputBox("type value of B here:") Workbooks.Open Filename:= _ "D:\Users\" & A & "\Documents\" & B & ".xlsx" End Sub...

Dear Forum Members, I am hoping you can assist a newbie here. The following is required from my VBA code: A cell input is made in the "Form" sheet and compared with a cell in the "Formdata" sheet. If the cells are different then a MsgBox is displayed with a warning and the cell is deleted...

Hi people! I'm fairly new to VBA and I'll appreciate your help on this. I have an argument in which I'm defining a named range, the argument is as follows: ActiveSheet.Names.Add Name:="JanMax", RefersTo:=ActiveSheet.Range(max) In this line, I'm creating a range with the name "JanMax" and it...

Hi I've been on another thread where I asked if it was possible for a user to run a macro that asks them to select a file on the hd to open. I was given the below code. It works well for selecting/opening another file, but what I would really love for it to do would be to assign the file name...

I'm writing a function that gets data from a worksheet with a name dependant of the value of a cell. The cells value (e.g. Sheet1) is called into the function as string_name. Essentially I want to transform this code xrange = Sheets("Sheet1").Range("I2:I20").Value into something like this...

Goal: use "If" formula in R1C1 to evaluate cell contents; if "true" use Variable, if "false" use Constant Issue: Constant works fine in all code snippets. Variable works fine when a number (Work_2) but FAILS when text (Work_1). Following are 3 different approaches I've tried to no avail. I've...