Search results

hreyo25, they are called CSE (CTRL+SHIFT+ENTER) formulas or array formulas. Note that Sajan had clearly mentioned this here

You can do that, but for that you'll have to rely on the Excel4 Evaluate function. You can define your name using the Evaluate function (that's the only way to make it work), and based on your formed argument within the Evaluate function, you'll be able to define it's calculation. Check the...

Shri, I wouldn't recommend using the keyword Global to declare a public variable. It was used in earlier versions of VB (2/3 and probably even before), and is now provided for backward compatibility (starting VB4). Global and Public declarations work the same way, except that one is not allowed...

Not sure if it's a rhetoric question, but the page where you picked the picture from clearly mentions that it's 'nearly' impossible. I am not sure if the writer just didn't want to completely dishearten a persistent developer, or whether s/he didn't have cent per cent faith in self, but I'd be...

X=SUMPRODUCT($E$31:$AH$31*($E$1:$AH$30=$A36)) Y=SUMPRODUCT($D$1:$D$30*($E$1:$AH$30=$A36))

Use this in Data-Usage!A3 =IFERROR(INDEX(MediaBuy!$A$3:$A$698,IF(COUNTIF(A$2:A2,A2)=INDEX(MediaBuy!$F$3:$F$698,MATCH(A2,MediaBuy!$A$3:$A$698,0)),MATCH(A2,MediaBuy!$A$3:$A$698,0)+1,MATCH(A2,MediaBuy!$A$3:$A$698,0))),MediaBuy!$A$3) And Data-Usage!B3...

OK. That means it could vary between contracts.

By A3, I assume you also mean the corresponding 3 columns, along with the 12 months. And in place of 12, it could actually be any number, based on your choosing, and also, it means that each contract will repeated for the same length. In your case for example, it was always 12. Are these...

:) I like the way you put it as Classic Split Trap. Anyway, it's easily fixed by a simple concatenation Sub SMC() Dim var As Variant, varOut As Variant, varFomat As Variant, lngRow As Long, lngRow2 As Long, lngCol As Long, lngIndex As Long Const clngSplitCol As Long = 13 With...

By the way, here's another attempt at your original macro Sub GetData() Dim strSource1 As String, deb As Workbook With Sheets(1) ParentDept = Left(.[G3], 4): dept = Left(.[G5], 4) ' fname = "\" & .[c3] & " - " & .[c5] & " - " & _ ' MonthName(Format(Date...

balaji, you need to copy it to a code module. Insert a new code module in your VBA project by going to the VBE window.

Sub SMC() Dim var As Variant, varOut As Variant, varFomat As Variant, lngRow As Long, lngRow2 As Long, lngCol As Long, lngIndex As Long Const clngSplitCol As Long = 3 With Worksheets("Sheet1").Range("B1:E7") var = .Value2 ReDim varFomat(1 To 1, 1 To .Columns.Count)...

Gosh! Same case here too as bobhc. My bad :D

So basically, you do not want to workbook to get opened when you click the hyperlink? If you mean by giving hyperlink to a portion of a working, you mean that you want to see the value of a cell in another workbook in your active workbook, you should be using a formula instead of a hyperlink...

Please attach the files. Without that, it's difficult to diagnose.

OK, I've modified the file based on SirJB7's feedback and based on what I understood. Still happy to hear inputs

Hi SirJB7! Thanks for the compliment and the feedback. Let me see how much I can rectify. by points a) and b), I assume you mean to say that the language should be consistent. If it's showing in local language, then everything should be in local language. But if in English, then everything...

So here's something that I did for fun some time back. My original work just had 3 rows for all the days of a month. I thought a gallery would be much better than a button. Brushed up some bits here and there. Feel free to give any feedback or suggestion. Apart from the feeling of sharing...

Just a wild guess Sub AutofilterMatchDay() If Not Isempty(Range("F1")) Then Range("A4").AutoFilter Field:=8, Criteria1:=Range("F1").Value End If If Not Isempty(Range("G1")) Then Range("A4").AutoFilter Field:=9, Criteria1:=Range("G1").Value End If End Sub

Either the column width is not adequate enough to show the contents of the cell, Or, you subtracted a date from a smaller date. If it's the former, then just increase the column width appropriately.

The code I posted will also take care of additional shifts and additional employees.

Sub SMC() Dim varInput As Variant, varOut As Variant, varShift As Variant Dim objDic As Object Dim lngR As Long, lngC As Long, lngIndex As Long Set objDic = CreateObject("Scripting.Dictionary") objDic.Item("Employee Name") = 0 varInput =...

saeed, not good at writing VB executable file. Sorry. Can anyone out there help saeed? I would ask though, what's keeping you from running this from Excel?

PB, you don't need an IF formula. The formula you should use is =A1="OK" The A1 above should be the reference of the Top Left cell of your selected range. So if your range starts from D5 to X50 for example, you should select D5 and drag the selection area all the way to X50. Only then you...

Sure. This is an example of how you can do it. 1. Click on the record macro button on the bottom left (Excel 2007 and above) 2. Give a suitable name to your macro 3. Assign some shortcut key (I've used CTRL+SHIFT+r) 4. Select Personal Macro Workbook 5. Hit OK 6. Now type something in the...