works

Hello all, I am confused with how the formula below works. What part of this formula makes the date know it's 2019? The result I am getting in B1 is Fri, 01/04/19 :confused::confused::confused::confused: Cell E3 - 1ST FRI EVERY JAN Cell F3 -...

Hi all, Need some assistance please. Have a formula that works justfine however I now need it to work based on a dropdown list in cell H1. The original formula was: =VLOOKUP($A9,SFG,10,0) and this was located incell P9 The new formula I’ve come up with is as follows...

Hi I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find works best for them. Are there any good guides knocking about to look at Cheers Joe

hi there, I have been trying to figure this one out but no combiation seems to be working. I have a table, called "ALLOCATION" in a sheet "RAW_DATA". I want to trigger another marco when a empty cell of column "DATE" is selected of the able table. I am using Excel 2016. Macro that I wrote...

Hi there. I want to edit the connections of the activeworkbook doing something like: Dim oCon For Each oCon In ActiveWorkbook.Connections oCon.Refresh BackgroundQuery:=False Next oCon The code above does not works. How can I do that? Thanks! EDIT: Better explain: I want to disable the...

Can someone tell me why this line isnt working? ActiveCell.FormulaArray = "=IFERROR(INDEX($C$2:$C$2000,SMALL(IF($F$372=$A$2:$A$2000,ROW($A$2:$A$2000)-ROW($B$2)+1),1)),"")" i get "unable to set the formula array" i know the formula works so... what gives??? im using this one on Excel 2010...

Hi I am looking for a macro/VBA code which will put a running clock into a cell showing the current time but I want it to run when the workbook is opened, I have looked and nothing I have found so far works for me I am fairly new to excel

Excel Home & Office 2016 on Win 10 Column B is formatted y-mmm Column F text is either "", "x" or "+" and this formula works if placed in a worksheet cell on row 13: =IF(AND(F13="",DAY(B13)<TODAY()-5),"True","False") Shows True if F13 is within 5 days of today If I place the guts of it in...

I use this on many work sheets and it works well. But i am working on a table and I think it is doing the entire possible range rather than the populated range. How can I modify this so it only works on populated cells? Sub ProperCase() awsn = ActiveSheet.Name ib = InputBox("Count What Row")...

I have a command button in my workbook, which is used to resent a column of values back to zero. The button works on both me and my husband's computers (we both have office 365, fully up to date) and also works on my intern's computer (older - office 2010). However, it does not work on my...

I am using VBA to automatically enter maximum & minimum constraints for a cells value in Excel's solver. I have named ranges in the worksheet that I use to input a user defined maximum/minimum for the value. It works for every value except when the user places "40" in the cell. When 40 is the...

I copied this code from Excel VBA: by Nein Smith and I can't get it to work. The data is a mixed list of number from 1-10 in Column A, color line works but the text line does not I know there should be a Then in this macro to the author was just trying to show how Conditional logic works, at a...

This VLOOKUP works fine. =IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"") But I need the results to be blank if there's no file with that name or if the file exists but there's no tab within the file with that name. If I could get these 2 problems worked out it...

Hello I have been fighting with a problem for a while with no success. I want to update a field on a webpage via excel vba. I am using IE11. Below is a picture of the source code of the page in question. I want to update the Value from 29 to 31 for example. I have tried getelementsby...

I've run into a curious problem. Using Data-New Query - From Oracle Database, I've created an ODBC connection to oracle (with a SQL statement). What I'd like to do is use VBA to force a refresh. My current method is using SSIS to execute a "Macro"/subroutine which works until it gets an...

If I want an error message such as "On error Goto Help" and then later "Help:" I would just do that. however, Excel is making me dim "help". How would I do that? As a string works but isn't right I don't think.

What I'm trying to accomplish is this: I have a customer field in C2. I'm trying to generate a specific hyperlink to different web pages in S38, based on the customer inputted into C2. I tried using data to make a =Hyperlink(vlookup function, and it works. As I switch the customer name...

Can someone help please - I have the following formula which works as it should for Column Z, but need it to work with if a value in Z, AA or AB please... =IF(TODAY()<J162,"", SUM(COUNTIFS($P$149:$P$157,"<"&$J161+7,$R$149:$R$157,">"&$J161+7,$Q$149:$Q$157,"YES",$E$149:$E$157,"<>OP...

I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...

So I have a checkbox on the page that I want to hide and unhide a row, playing the script it works perfect but when I click the checkbox it only works once but wont uncheck and unhide. Im sure its simple but I'm missing it somewhere. I have the checkbox declared as a variable already when I...