arg

As the title says there is more. I have some data (soccer scores). What I want to do is pull the date of the last game PLAYED by each team. I used to have a formula but I can not find it to the best of me. <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody>...

Hi, I am trying to match the string typed into a user form against the windows password, how can I do this? There are no passwords stored anywhere and the string that is typed is covered by stars so the passwords won't be visible when typed. The code below is from Expert Exchange Option...

I seem to recall being able to do this but it's been 10 years since I last used the trick. Here's what I have so far. I adapted some code I found searching for how to answer this question. Here's the particular line I think I need to change: ' OPEN THE SOURCE EXCEL WORKBOOK IN "READ ONLY...

Hi all, I'm trying to use this argument (arg): 'T:\SUPERVISOR REPORTS\2018\[May 2018.xlsx]10-D!R7C2 like this: GetValue = ExecuteExcel4Macro(arg) BTW, arg is created like this: arg = "'" & path & "[" & file & "]" & sheet & "!" & Range(ref).Range("A1").Address(, , xlR1C1) (it was found...

This is totally baffling me, and should be incredibly simple. I have this test function: Function TestFunction(arg) Range("Q17").Value = arg ' Does not work TestFunction = arg End Function If I execute it in a cell with the "Range" line commented out it works fine and...