2,449 reputation
1819
bio website awmisfits.com
location Texas
age 46
visits member for 2 years, 5 months
seen Oct 21 at 15:53

Afterworld player, and forecasting/VBA/excel/access to support the habit :)


Jun
21
comment Change the Point Color in chart excel VBA
see stackoverflow.com/questions/11136194/…
Jun
21
answered MS Access: Force input mask characters in field
Jun
21
answered Run a .bat file upon logoff, windows XP, no domain controller
Jun
20
answered CPU operating temperature ranges
Jun
20
revised Windows 7 losing one of my displays after restart
removed extra stuff in header
Jun
20
suggested suggested edit on Windows 7 losing one of my displays after restart
Jun
20
comment How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
try removing the Worksheetfunction - it's evidently optional -> Application.VLookup(FindList(I), DataRange, NumberColumn, False)
Jun
20
comment How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
Also, if the value is not found in your table, it will return 0, and the err.number will be set to indicate this.
Jun
20
revised How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
edited body
Jun
20
comment How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
this is the VBA way of using the vlookup function. For each of the values you have separated by commas, it will look for the value in column 1 of your range, and return the matching value in column NumberColumn of that range. if you want to try the function manually, then you can use VLookup("A", Range("A1:B5"), 2, False) to find A in area A1:B5, and return the value in the 2nd column
Jun
20
answered Specific issue with long pathnames in Windows 7
Jun
20
comment network share on external harddrive gone after restart
"Freigabe" = "Share" in this context
Jun
20
answered How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
Jun
20
revised Can't access shared folder from another PC using a user with same name and password
put meaning of SID next to the 1st use of the abbreviation.
Jun
20
comment Can I use any audio interface with the Pro Tools 9 that comes with an Mbox Mini?
creating tags required 300 reputation, so that we don't have misspelled tags that link to spam websites
Jun
20
answered Can't access shared folder from another PC using a user with same name and password
Jun
20
answered How do I split an internet connection into 4 equal connections?
Jun
19
answered VBScript check if key combo pressed
Jun
19
answered How to resolve #NAME? error in Excel?
Jun
19
answered Disable Number Pad in Windows 7