syntax

Wish you all Happy New Year Hello 1. What would be the syntax for the following to write in txtAmt.text =IF(AP6<$D$2,AQ6,0)+IF(AS6<$D$2,AT6,0)+IF(AV6<$D$2,AW6,0)+IF(AY6<$D$2,AZ6,0)+IF(BB6<$D$2,BC6,0) the above is written in BF6 Cell so that anyone opening the sheet gets the cell value as...

Oh oh, what I do wrong? I am on a sheet. On a second sheet I want to define a range, and do a search in that range... Set c = Worksheets("CONFIGURATIONS").Range("A2", Cells(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column)).Find(Worksheets(ActiveSheet.name).Cells(1...

Hi I want to save as a workbook so I wrote the code below. It works fine, it gives me the window below which is save as window but when I click No (so I can pick macro enable file), I get this error message I know I am not following the syntax of Save as, but it used to work just fine...

D = PA.Worksheets(g).Range(Cells(B, "A"), Cells(2, C)) receiving an error on the above line, not sure what is causing it...B, C are both integer variables, g is a string variable, and PA is a workbook variable. Syntax?

I have this line of code: .Range("B23").Value = "October " & Range("E18").Value E18 has the current year and I need the range in cell B23 to be October & the following year. It works to get the current year in B23 but I wasn't sure of the syntax to get the following year.

I have seven day columns, with blanks and entries, I have a formula to identify the last ROW of each day, and use a MAX function to return the row number. so far so good I need to use =COUNTBLANK(M14:S34)+COUNTA(M14:S34) and =COUNTA(M14:S34) to be able to identify the difference between...

I have a monster of a syntax and I can't figure out how to incorporate the function below into the existing string. I want U24 to calculate SUM(S24,T24)*P24*E24 IF("DECKING" populates G24 Here is the syntax...

I'm trying to add some features to an existing formula so that if G/454= "ALLTHRD" "HDD_STUDS" "THRDD_STUDS" "DEFORMBARS" or "REBAR" are used in the drop down window, the target cell M/454 will display a blank and multiply O/454 by E/454. Here is my current syntax and link to screenshot...

On one worksheet I have a scrollable textbox. I am finding it stays 'scrolled' where the last person left it positioned, be it the middle or bottom or wherever. I want each time the worksheet is activated to ensure the shown text starts from the top. I can make the textbox visible or hidden...

Good morning, I am working on a seemingly very simple update query and I am receiving a Syntax Error. So far, my searches have not found similar issues, so at the moment, I am lost. The query was originally an Append query, then I clicked on the Update button on the ribbon. This is the SQL...

Hi, Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure: Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] ) I was hoping I could just do something like this: Avg Number of Units =...

Hi I am still learning Excel and I am very grateful to the good folk on here who generously give their time to answer all of our questions - Thank you. I am writing a simple If formula that looks at cell B1 and if B1 contain the number 1 the formula does one thing but if it contains a different...

Could someone please let me know if my query is correct...I keep getting a syntax error? iif(Sum([Assignment_test]![CountOfPlanNumber]+[Assignment_test]![InvComplete])=0, "Complete", "Incomplete"))) AS Expr2 FROM Assignment_test;

I'm using VBA to paste a VLOOKUP formula in one worksheet based on a table array found in another workbook's worksheet. I created a macro in Excel to try to get the correct syntax: =VLOOKUP(G2,[Book2]Sheet1!$B$2:$AH$100000,33,TRUE) but when I try to paste it from Access VBA...

Range("'Exhibit " & """I"" "'!$C$3:$D$3").clearcontents I have a worksheet called Exhibit "I" and inside that worksheet I have various ranges that I would like cleared when this workbook opens. This is just one of many ranges I would like cleared. The above code returns a syntax error. How can I...

Hey All I can't seem to get the syntax right for this and I'm at the point where I'm understanding it less the more I read :/ I'm trying to copy from one worksheet to another with a variable paste range but I can't seem to get the paste part to work, this is what I originally thought would...

I've been searching and searching but I can't seem to find the syntax for a measure that will allow me to count the number of Mondays within a date range. The date range will be selected through a slicer on the same page. What is the DAX syntax in order to do this? Thanks!

Hi all, I need to enhance the formula: =IF(INDEX('Salesforce Combined Data'!$P$3:$P$9999,MATCH($B4,'Salesforce Combined Data'!$C$3:$C$9999, 0))<>"","*","") Right now, it checks if there is a value in a cell on another sheet. If so, instead of showing the actual value, it shows an asterisks...

If cell A1 contains a different cell reference (in my case it changes but will always be of the form B6, never $B$6 or B6:B9) can somebody help me with the VBA code syntax to enter some other data (always a strings eg "SUCCESS") into whatever cell A1 references at the time.

Hello, let's say I'm doing a COUNTIF across two sheets. The first sheet is Dashboard, the second is data. The formula is being entered on "Dashboard" When I am flicking between the two sheets as I fill in the range and criteria, I end up with something like: [criteria_range1] [criteria1]...