defined

Apparently if a string represents a date then it can't be used to set a defined name. My VBA statement ActiveWorkbook.Names.item("latestDate").Value = latestDate where the variable latestDate = "2/19/2018" sets the defined name latestDate to "=43150" How can I set the named field to...

I am trying to use R1D as a cell NAME in a CELL. it doesnt start with a number it doesnt have a space and it is not already defined and it isnt a cell reference. just academic at this point . . thanks

Hi all I'm trying to use the following code to input a formula but for some reason I get an application defined / object defined error for the 'iferror' formula I'm using. ws_catalogue.Range("D3").Formula ="=IFERROR(INDEX('Test Input'!$E:$E,MATCH(CONCATENATE([@Actor],[@Entity],D$1),'Test...

Hi I keep getting this Compile Error message User defined type not defined when i run a code This is just a snipit of the code Public Sub IE_Whitepages2() Dim IE As InternetExplorer Dim URL As String Dim HTMLdoc As HTMLDocument Dim phoneDivs As IHTMLElementCollection...

Hi, I have a defined table in cells A5:B9. Every week, I am adding another row. Is it possible to place a transposed version of this table in C1 that updates automatically? Thanks!

Hi, I am trying to collate a number of different spreadsheets using VBA to achieve a complicated layout. The following code exert should find a string within a calculated range: sDate2 = wbFMPPrevious.Worksheets(wsDestination.Name).Range(Cells(nPrevAvail + 2, 1), Cells(nPrevAvail + 11...

Hi Guys, I have been using this code successfully to save my file to our company's intranet Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx" this code has all of sudden has...

Greetings, I am trying something new and wanted to share my ideas and get some feedback and potential resources that could improve results before I jump into construction of userforms and subroutines. I would like to build a tool that is GUI friendly using Excel Userforms and VBA subroutines...

Hi Guys, I have been using this code successfully to save my file to our company's intranet Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx" this code has all of sudden has...

Hello, I was looking into "dynamically defined names", but am not sure that's what will work for me... I have values changing in column A, and based on that value, the cells in column B (same row) should have a particular defined name. But there could be several possible dynamically defined...

Hello, Been getting sub or function not defined when using: Outlook.Application IsAppRunning Does anyone have ideas I'm pulling my hair out, chances are it's something in tools/references but I'm confident I have what's required ticked... Luke

Is it possible to dynamically assign a hyperlink to a button, based on the value of a cell. That is, so that clicking on a button links to a URL defined in a given cell? Thank you!

I have a problem that I'm not sure can be solved in a simplified manner. What the code below is doing: Takes the LEFT 3 characters on sheet1 (airport code) and looks up the airport code in sheet2 and returns the 2nd column (city). Before returning TRUE or FALSE, it tries to see if the first 4...

Greetings, I am receiving an application or object defined error on the below line. h is a range variable, AC is a string, k and b are integers COM.Worksheets(AC).Range(h, h.End(xlToRight)).Select For Each ws In COM.Worksheets AC = ws.Name k = Cells(Rows.Count...

I am receiving the "Application Defined or Object Defined Error" on line Selection.End(xlToRight).Offset(0, 1).Select The entire chunk is this: COM.Worksheets(AC).Activate Cells(j, 1).Offset(-1, 0).Select Selection.End(xlToRight).Offset(0, 1).Select b =...

I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got run time error 1004 application defined or object defined error the apparent cause of the error is highlighted in bold below. { code Set DataSheet = ActiveSheet...

Hi All My First question post on this forum. I have searched extensively however i was not able to get anywhere with the following statement. My aim is to delete rows if conditions for Column F and G are not met. If column F has a certain value and Column G doesnt have defined 3 values I would...

I have two tables where one table will populate the data into the other table based on the section and item number I have defined. As per the below image the table in yellow will be populated by the table in white. For example D2 needs to show the value from D48 as the 'Section' and 'Item'...

Could some one please help me with a formula that can give the smallest value within a defined range. So let's say in column 1 there are vales and in column 3 I have manually copied the smallest values between 1-1.9999, 2-2.9999 and 3-3.9999. Is there a formula I could write in column 3 cells...

Hi, When I run a macro with the line "Dim PPApp As PowerPoint.Application" from a module within my PERSONAL.XLSB it works fine. However, when I transfer the code to a module within a workbook, it returns the error "compile error - user defined type not defined". Thanks in advance for your...