Reputation
2,562
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
1 9 19
Newest
 Yearling
Impact
~474k people reached

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?
Aug
20
comment Adding table values between an undefined list of worksheets that keep data key associations
are you guaranteed that id 1 will be on row 2, id 2 on row 3, etc., on every sheet, or could the positioning change?
Aug
19
answered Changing line insert default formatting
Aug
19
answered Office 2007: .xls file opens excel with no workbook. “Ignore other apps that use DDE” already unchecked
Aug
9
answered registry setting for IE's compatibility view settings to add a site?
Jul
31
comment windows 7 batch file for swapping filenames randomly
This random swapping reminds me of the ripper virus, which swapped information to corrupt a disk slowly. I would be wary of answering this question, as it seems to have a malicious intent (even if op wants to do this in jest)
Jul
31
comment Calculate different discount levels in Excel
@Grethe , Please accept the answer by ticking it, this will mark the question solved. For the details see: Accepting Answers: How does it work?
Jul
30
comment How to start applications automatically when Windows starts with a time window
@Nikolay, sleep is not available in XP
Jul
30
comment sum sign in number cells
Function Kikio(Rng As String) As Variant // Kikio = Evaluate(Rng) // End Function
Jul
30
answered How can I get the string of a cell?
Jul
30
answered How to start applications automatically when Windows starts with a time window
Jul
29
comment Adding mail header as column in Thunderbird
I don't know if you've looked at this (or if you could adapt it) but the spamness seems to add a column based on the score
Jul
29
comment How to find out what server an application is trying to connect to?
Without knowing the application, we would have no idea where its config file would be. Some use the Registry, some use the program directory, some use the User profile, and at least one (badly behaved) program edited the executable for its configuration
Jul
29
comment “Show window contents while dragging” keeps getting disabled
is it a Dell? (seems most work computers are) Dell Media Experience does this change. 101-computer-troubleshooting.blogspot.com/2009/09/…
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