reference

All of a sudden one of my macro workbooks starts producing an Automation error when I execute this command: Sheets("Categories").select The rest of the error message is "Invalid forward reference, or reference to uncompiled type". I tried renaming the tab and I've verified there is nothing...

On Sheet1, I have a data range D9:AH29. https://www.dropbox.com/s/j3dq7acp2uet463/Data.png?dl=0 On sheet B, I want the total of each column. Currently I am using the formula =SUM(Sheet1!D$9:D$29) in Cell A1, =SUM(Sheet1!E$9:E$29) in A2, =SUM(Sheet1!E$9:E$29) in A3 and so on. The problem with...

I have tried to write some code but it won't work. I want the code to get the last number in column A of the sheet "Reference", file name: client_list.xlsm and add a 1 to it. I then want the new number inserted in the row under that row in column A. I also want the new number inserted in cell H5...

I have created spreadsheet that creates quotes successfully but my supervisor has asked me to add some sort of a reference so the quote can be identified. There is a file client_list.xlsm that has the client name added too when the quote is finalised This code will be run from my quoting...

I have wrote a dll in visual studio. But when I try and add the .tlb file to the reference dialog box it tries to add it but doesn't show up. Also there isn't an error when I try and add the .tlb file. I'm unsure on what the problem is. The subs in the dll are also not able to be referenced...

Hi, I have an Excel macro that requires a reference (DLL) and if the DLL isn't found I get "Compile Error, can't find project or library" Is there a way I can handle this error by checking if the DLL exists then msgbox / exit sub Thanks for any help

Hey there I am creating a template which has a variables set up page. On that page I want to provide the user the ability to enter values into cells which generate tab names. There is a finite number of tabs - so want to have a direct link between a cell reference and a specific tab name...

I have in column A various strings, and a rule that highlights certain ones in red. Is there an easy way to get the reference of the first cell that has been highlighted? For example, if the cell on row 53 is highlighted, I want to get "A53" I tried FormatConditions.Count but that only tells...

Hi, I got the final column from the code below. finalCol = ThisWorkbook.Worksheets("Daily Totals").Cells(2, Sheets("Daily Totals").Columns.Count).End(xlToLeft).Column How do I set a range to reference G2 to finalCol & row 2? The following code is only for reference to help explain what I...

Hi all! I'm trying to activate the Microsoft Scripting Runtime Reference within my code as I'm using FSOs in other parts of the code. I don't get any errors, but it's not activating the reference either. The path below is my actual path. Any help is appreciated. Thanks in advance! Sub...

Hi, In Column A I have dates, and in Column B I have text ‘LARGE’ or SMALL’. In Column C I want to reference the date from Column A with the condition that if the text in Column B is ‘SMALL’ then it adds 60 workdays taking into account a holiday range in Column D cells D1:D7. If the text is...

Hi all, I have two columns of data in excel with the headings - Reference and Result the first cell (A2) in column 1 is a unique identifier the second cell (B2) is the result the issue is that the data in B2 are multiple results delimited by either a tab, quotes, space, asterisk, comma...

Hi members I have a trouble when I add references from file path using vbProj.References.AddFromFile "C:\Windows\SysWOW64\ieframe.dll" and vbProj.References.AddFromFile "C:\Windows\SysWOW64\mshtml.tlb" I receive a message "No se puede entrar en tiempo de interrupción en este momento" Also...

I am using the below formula but always get a reference error when I delete row 14. I always want it to reference C14 even if the row is deleted. Any idea how to incorporate an absolute or index in this formula? =EOMONTH(C14,0) Thank you to anyone who can answer this!

Hi - I am trying to do a nested iferror/index/match/countif array formula - my formula works - but when I use a reference made from =address, I can't get it to work. The =address reference is the max point for searching in my formula - it would be repeated a few times. any ideas? just a...

Afternoon Everyone, I hope someone can assist with a small problem. I want to get a formula which searches 2 criteria and return a answer. It's like a Vlookup but with an additional criteria. I've tried consolidating the cells but someone told me that using INDEX and MATCH are a better was to...

Can someone assist with this error... I created a text file and naming the file with the cell value. However I'm having trouble writing the reference code below. Public Const ObscureFile$ = Sheets("Security").Range("IQ2") & ".Log"

hello all this is the formula i have which works great which references a worksheet but i also need it to perform the same commands and keys but from another worksheet IFERROR(INDEX(T_LEAVE56[TYPE OF UNIFORMS],SUMPRODUCT(--(T_LEAVE56[EMPLOYEE NAME]=$B9),--(T_LEAVE56[START...

So I have a basic Macro to select some data and create a chart - this works perfectly. The problem I have is that I need to create 78 of these charts. I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and...

Hi All I would like to have 6 cells in a sheet with each one representing a position. I would like the header and footer on every sheet to reference what's in each cell. Possible? Thank you!