defined

Hi All, I have created a combo box and would like to execute VBA according to selection from combo box. I have used the same VBA code previously without any error. But since I upgrade to excel 2016 I got error message as shown below. Not sure if it's due to 64 bit system? Can anyone here shed...

Hi there, I tried to combine sheets with different columns to a new sheet. and ran the code. but it says user-type not defined. following link to the workbook: https://1drv.ms/x/s!Aqt4VfikFsyKdP__4BbJF1LMxlM could anyone help me to run a debug? Thank you in advance !

Can't seem to get the right formula for Non-Conformance Closure Cycle time to measure how well one aspect of our NCR process is working. NOTE: All of the information I am working with is DATA-LINKED from another system that can't be modified easily due to the front end design of the input...

I remember seeing on a You Tube video where the user used short cut keys to bring up a list of defined names when he was creating a list in Data Validations. Does anyone know what that short cut was?

Hello all, I'm trying to enter 2 formulas in a range of cells in my VBA routine but i keep getting Debug errors upon execution (Run-time error 1004: Application defined or Object defined error). These are the lines of VBA i am trying to use: Range("K2").Formula =...

Good Day, I am trying to automate a task in a tracker where I have a defined date, when this date has passed I wish to create a macro that will add 1 month to the date then adding an amount to an outstanding balance. updating the defined date in the process. I have attempted to do this using...

Greetings, I am trying to put together a user defined function called risk of ruin. I would like it to output the probability associated with the occurrence of the 'bankroll' variable falling to <= 0. I am receiving 0 values as output for some reason. My graphing calculator and wikipedia...

I want to enter the following formula's in two cells: Range("D61").Select ActiveCell.FormulaR1C1 = "=SUM(D58:D60)" Range("D63").Select ActiveCell.FormulaR1C1 = "=COUNTIF(IG_TxnHist[ProfitAndLoss];"">0"")-1" the result in D61 is =SUM('D58':'D60') and returns a #NAME ? error. How...

All, I have created a name in the name manager I called it "l3nox". The data can be pulled how ever I want it to so the amount always changes. I then graph the data based on the name I have defined. Here is the equation for my name. =Sheet1!$F$6:INDEX(Sheet1!$F:$F,COUNT(Sheet1!$F:$F)) For...

Hi, I have a workbook that I've used for years. I know it's not best practice but the variables are not defined. This has never caused an issue, it has always worked fine, but today it is giving me a compile error on every variable unless I dim them. Option Explicit is not set, neither is the...

Hi, I have a defined list as a drop down. Is there a way to add to the top of the list something like 'Select Value' in the formula and not in the defined list? Many thanks

Greetings, I am currently receiving a Expected End of Statement Error on the following line. wkbk_LO.Worksheets(c).Range(Cells(g, "A")).value = "=INDEX(PERSONAL.XLS!LOGIT([LOGREG_INPUT.xls].worksheets(c).Range(cells(2,"B"),cells(g,"B"))...

I have a line of code that was looking at the beginning and ending spreadsheets, but now they are adding more spreadsheets so instead of certain sheets defined I would like it to pop up a input box. Here is the code I have currently: "=IF(ISNA(VLOOKUP(C2,'12-31 TO...

Hi all I've written a module that runs through a table column of workbook paths It opens each workbook Refreshes the data connections Then refreshes the the pivot caches Then closes the workbook However, once the second workbook opens I get 1004 application defined or object defined error...

For Each Cl In Range("C2", Range("C" & Rows.Count).End(xlUp)) If Not IsError(Application.Match(Cl.Value, Columns(2), 0)) Then _ Cl.EntireRow.Interior.ColorIndex = 28 The above code is working well. My question that I'm not entirely sure about, what "C2" is for? I don't believe it to be...

Set arg1 = Workbooks("COMM_COMBINED_INDEPENDENTS.xls").ActiveSheet.Range(Cells(7, a), Cells(e, a)) I have been looking at this line for a while now and I can't seem to determine why I am receiving the error "Application Defined or Object Defined Error". I have all the variables on a watch...

Sub Demo() Call CountfilesInFolder("C:\Users\kamal.j.kumar\Documents\CDP", "*.xls*") End Sub Hi, In the above macro, I get the following compile error: sub or function not defined. Why ?

I'm customising a social media bot that autoposts from my notetaking program. What I am trying to figure out is seqential timestamping within a defined range. I've been able to get parts working with IF statements, but I'm struggling to get the 'queue' portion to work. Here's what I'm looking to...

Greetings, I am receiving an application defined or object defined error on this line... not sure why this is giving me an error. Variable values are defined as integers. Looks similar to many of the example online, but... My intention is to set a range object that changes within a loop. Set...

Hi All, i am getting a error sub or function not defined in vba, can any one help. Sub xyz() counter = 1 Sheets("Sheet3").Select For k = 6 To 200000 DOBval = Cells(k, 1) If Mid(DOBval, Find("", DOBval + 1, 6)) = "App.No" Then DOB = Cells(k + 1, 1) counter = counter + 1...