2,449 reputation
1819
bio website awmisfits.com
location Texas
age 47
visits member for 2 years, 7 months
seen Dec 20 at 14:48

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


Jun
22
revised how do you use RunSavedImportExport from a macro
changed to correct "access" tag
Jun
22
suggested approved edit on how do you use RunSavedImportExport from a macro
Jun
22
answered how do you use RunSavedImportExport from a macro
Jun
21
awarded  Organizer
Jun
21
revised VBA script in Outlook 2010 rule
added correct outlook tag
Jun
21
suggested approved edit on VBA script in Outlook 2010 rule
Jun
21
comment MS Access: Force input mask characters in field
I have no idea why that would happen - I'm in US, so don't see any changes if I use slashes or not
Jun
21
comment Show Excel column filter information in cells
the workaround for that is =CheckFilters(A3:E3) & &LEFT(SUBTOTAL(9,A5:A200),0) really, any function that makes it re-evaluate on a spreadsheet change
Jun
21
comment Specific issue with long pathnames in Windows 7
then pkzip - zip everything up, then extract them without the directory structure. You may have to use the command line version to do this step
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 What are the recommended operating temperature ranges for the AMD Phenom II 960T?
Jun
20
revised Windows 7 losing one of my displays after restart
removed extra stuff in header
Jun
20
suggested approved 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