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 :)


Jul
29
comment MS Excel (2003) Is there a bug in DSUM or am I missing something blindingly obvious?
@Raystafarian - Ok.. Got enthusiastic when changing formula - did a search and replace for AR to BT, and completely forgot it would change the country reference. I'll leave the comment for my D'oh moment
Jul
29
comment MS Excel (2003) Is there a bug in DSUM or am I missing something blindingly obvious?
I also see that RS have never voted, so you will always get #VALUE! for that column
Jul
29
answered MS Excel (2003) Is there a bug in DSUM or am I missing something blindingly obvious?
Jul
29
comment MS Excel (2003) Is there a bug in DSUM or am I missing something blindingly obvious?
I can't find DSUM in your workbook. Did you upload the right one?
Jul
24
comment Acces VBA code combination not working, issue with exit sub?
use this for code indenting - it will show you the levels and make matching if/endif and other like constructs easier. It works in Office 2007 and 2010, but the website does not show those
Jul
22
awarded  Tumbleweed
Jul
22
answered Split column into multiple columns--datewise
Jul
22
revised Split column into multiple columns--datewise
added info from comments
Jul
22
suggested approved edit on Split column into multiple columns--datewise
Jul
22
comment Modify existing private VBA sub?
do you know which worksheet the code is tied to? The Worksheet_Activate is for a specific worksheet, and would not appear in a separate module
Jul
22
revised How to simultate 3 monitors on a system that only has 2 monitors?
added experience on use
Jul
22
answered How to simultate 3 monitors on a system that only has 2 monitors?
Jul
17
answered Table of Contents and pagination in Word 2010
Jul
17
revised Match multiple time-series columns?
added 2013 tag, reformatted examples to line up
Jul
17
suggested approved edit on Match multiple time-series columns?
Jul
15
answered Create custom base URL for ID number
Jul
15
answered MS Excel: is 'ABCD always exactly the same as =“ABCD” in a cell?
Jul
15
comment Mark sender as non-junk email sender in Outlook 2013
office.microsoft.com/en-us/outlook-help/…
Jul
15
comment How to impede Linux shutting down my computer unless I explicitly want it?
possible duplicate of stackoverflow.com/questions/322254/… or unix.stackexchange.com/questions/34489/…
Jul
15
comment Find match in Excel 2010 from 2 sheets & copy corresponding contents from sheet 2 to sheet 1
@Jerry, vlookup would work if the columns were swapped (what you are searching in 1st column, result in 2nd column) but a mix of index( & match( would be needed if columns are not in that order