2,449 reputation
1819
bio website awmisfits.com
location Texas
age 46
visits member for 2 years, 6 months
seen yesterday

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


Oct
8
revised Can I delete empty recovery partition (Win8)
added picture inline, instead of external link
Oct
8
revised Old MsWord file opening with junk characters
removed spam tag
Oct
1
comment Link Excel workbooks so that I can use them on another computer (Excel 2011 for Mac)
excel stores relative links only when the path is on the same drive. see this for further info
Oct
1
comment Alphanumeric cell format (using custom format)
A shortcut to make a 5 character zero padded string would be right("00000" & splitstring(1),5) - no loops or extra variables needed. Your entire string construct would be splitstring(0) & "\" & Right("00000" & splitstring(1), 5) & "\" & Right("00000" & splitstring(2), 5)
Oct
1
comment Avoid horizontal scrolling on websites
squarefree.com/bookmarklets/zap.html#force_wrap may help - it's an old site, so Chrome is not listed, but many of these bookmarklets work in (almost) all browsers
Sep
25
comment Check if path to file is correct on Excel Column
sneaky trick to remove reliance on the default of the boolean variable: FileExist=Len(Dir(path))>0
Sep
25
answered Replace Pivot Table row names
Sep
25
answered How to sort only part of multiple columns in Excel
Sep
25
comment Is there a keyboard shortcut to turn a tab-delimited recordset into a table?
are any of the letters underlined in the menu selections? if so, you can use ALT+UnderlinedLetter to select those specific items
Sep
24
comment Formula to add minutes to date+time in Excel
the reason the TIME formula does not work is: The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999 [which means that after 24 hours have been added, it wraps around again - see what happens if you add 1440 minutes using this method]
Sep
24
answered Is it possible to log out of Chrome using the command line?
Sep
23
answered How do I seed another data table's records with category information in another Excel data table?
Sep
18
answered Can I use an IF statement as a parameter in a COUNTIF function?
Sep
18
comment What is the rationale behind safely removing USB media from windows PCs?
@SqlRyan, here's a paper on the effects of power loss and write errors
Sep
3
comment Redirection from email addresses bound to site that asks them
trashmail.net - you have to pay if you want more than 10 forwards or a lifespan of more than 1 month, but it's great for creating an email address for those that require activation, and you can always update the email to another trashmail, or to another more permanent email once you trust them
Aug
29
revised Issue with spaces in path name in Excel macro
formatted code, removed thanks and poster's name
Aug
29
suggested suggested edit on Issue with spaces in path name in Excel macro
Aug
23
answered Moving and rename a file by its directory name
Aug
23
answered Is there a way to have the topmost \ point to another drive?
Aug
20
answered Filter for first unique instance a column in Excel?