variable

Hi, I wish I could have your help to solve what is a "big problem" for me in VBA. Let me try to explain. I have in column A a series of number, no blank cells. This is a dynamic serie, adding new data every day. In cell C1 I have a variable, a number that I choose. How can I get a formula in...

Hi, I'm trying to make myself a cleaner coder, and hopefully write code that does not slow down every time I run it. Can anyone help me with a list of variable types that need to be set to nothing or unloaded from memory manually at the end of a macro? Thank you, Daniel

Hi all, first post here. I've been learning VBA, and I've found the best way for me is to jump into exercises I've never done before. I recently came across a problem and decided to take a shot at it. I'm trying to use VBA to solve for the equation A = (B/C)^D, where any one variable A, B, C...

Hello, I'm attempting to use a find function in my code. Yet, when I run it, it puts the value of the cell into the variable and not the range. Could someone please tell me what i am doing wrong? Sub Saving_Crack() Dim IDnum As String Dim filePath As String Dim crackIDnum As Range Dim wt...

folks, i am working through a reformatting problem in another thread and came to a new problem along the way. Find and Findnext: in my active range, i set two variables to find. Set c = .Find("DEBT2.P33", LookIn:=xlValues) Set d = .Find("Previous Months Adjustments:", LookIn:=xlValues)...

Hi, I've written some code in VBA which creates a new tab based on a cell value. As you can imagine this cell value can change. After creating this tab i wanted to paste some information into it. However, I cannot call the tab; i'm getting error 9 subscript out of range. Or Object required...

Good morning, I am a little bit lost here, the code was working fine, I don´t remember changing anything, and suddenly now is giving error. Already spend a few hours around this matter and I still don´t understand why is giving this error. Run-time error '91': Object variable or With...

I have a Sub that loads a userform I created. In the sub, I change a label caption in the form and reuse it using a loop to capture the user's option selection for each new context (but with the same options presented). Load frmExample With ActiveSheet For x = 1 To UBound(vValue)...

Hi Forum, Some help req'd with passing a variable to a pivot filter. How would I amend the following code such that PivotItems("99999") could be replaced by the value from a cell - a named range, [CandID_Picker]? The Pivot Table needs to filter on CandID_Picker - and nothing else. With...

I've been working with VBA and Python recently but I've never combined the two. I'm just trying to get my head around how the 2 communicate with each other. Is it possible to set a variable in VBA and then Python can read the value of the VBA variable? For example, if the VBA variable was from...

Among many inexplicable problems is this. I recorded a macro to sort a spreadsheet using Column A as the first key. The pertinent code that Excel generated is ActiveWorkbook.Worksheets("CurrentWines").Sort.SortFields.Add Key:=Range( _ "A2:A237"), SortOn:=xlSortOnValues...

Hello, I am trying to automate a linear regression but want it to work for variable sized data sets. This is what I have for a given set. The Y data always starts at X5 and the X data always starts at Y5, but the length of the column changes. Any ideas as to how I would allow for the regression...

How can i save only the number of active cell address as a variable in vba code for example cell address is I$I4078 and in need 4078

Hello all, Long time lurker, first time user.... So I am trying to retrieve dates from a lot of filenames. The dates and file names can be variable and I am at a loss... Ive been messing around with right() mid() Left() split(), but no luck... Here are a few examples for file names. text -...

Hi, I've had a search but can't find a similar question. I am trying to get whatever a user has just typed into a cell and copy it to a different worksheet. I figured this was best to run in the SheetSelectionChange section, the idea being someone types something into cell B4 (or any cell)...

Hello, I have a "variable" (I think its called), called LastRow. And LastRow will find the latest row with data in special column. But if LastRow is empty. It will cause problems and delete information. Can I in some way set a minimum LastRow range? All help would be awesome! LastRow =...

Hi All, I'm trying to enter the formula =average($B$" & ProductRow & ":$KL$" & ProductRow & ") into cell "Cells(PivotRow, 3) onto my page "Pivot Data". My Line of code is the following Cells(PivotRow, 3).Formula = "=average($B$" & ProductRow & ":$KL$" & ProductRow & ")" This works except for...

I make a selection in a Userform.Listbox with data coming form the Textbox in a Userform Can I pass a variable to the Textbox Sub ..._Change event ie. Sub TextBx_Change(ByRef ....) I don't want to use a Public variable Thanks

Happy Friday, I'm very familiar with excel, but not so much with VBA. I'm creating a form with drop downs and one "enter" button at the bottom. When I go to test I get a Variable not defined error with PrivateSub CommandButton1_Click() highlited in yellow along with the (x1Down). Help...

Hi Friends, I have a string and a variable called "Formula". I want to append this string with my variable and update this value in the Cells(Lastrow, 3) of my active sheet. String is : “=IFERROR(IF(O9=” + Formula + " ;””);”Missing Leader Price”) " Note : Orange part is my string I tried...