174 reputation
110
bio website
location
age
visits member for 1 year, 8 months
seen Sep 23 at 23:29

Aug
31
awarded  Notable Question
Aug
16
comment Fake windows update
@DSchlachter that is well within the capabilities of most industrialized nations' spy corps.
Jul
18
comment Deleting range of cells based on criterea
@Dincky Can you post the existing VBA, and also explain what you mean by "Overlapping" or "Double dates"?
Jul
18
comment In Excel, can you create a cell that updates the number of another cell without having to hold the inputted value?
@Jason You have to save the file as .xlsm in order to be able to use VBA. If you save it as .xlsx, all the VBA gets disabled.
Jul
17
comment How to make a named cell read-only
You can also change the protection on cells from VBA. Check out mrexcel.com/forum/excel-questions/…
Jul
17
comment How to make a named cell read-only
You have to protect the sheet (optionally with a password) -- that makes all the cells readonly. Then selectively enable certain cells that you want. Look up cell protection in the Excel documentation. If you're in Excel 2007 or later (you should be), check out the "Changes" area of the "Review" tab on the Ribbon.
Jul
17
answered excel spreadsheet average with prioritization
Jul
17
answered How to make a named cell read-only
Jul
17
awarded  Commentator
Jul
17
comment How can I modify a lot of values easily in Excel?
You can also multiple select the columns if they're not adjacent by holding down the control key (maybe command on Macs) while clicking the columns, then do the paste special multiply.
Jul
17
answered Conditional formatting excel conundrum
Jul
17
answered Deleting range of cells based on criterea
Jul
15
comment excel 2010 is appending a space to the end of currency field when saving a csv file
Most likely the space is there to make room for the trailing ) when the number is negative. If you use a different number format, one which doesn't enclose in () when the number is negative, this won't happen. Seems like an undocumented "enhancement".
May
28
awarded  Popular Question
Jan
10
awarded  Popular Question
Jan
2
comment Automatically change ownership using WinSCP?
It's somewhat dangerous to login as root, even over a secure connection. Many of the attacks on SSH/SCP have been ways to trick the file transfer client or server into using no encryption. It would be better to create a special account just for uploading, with as restrictive permissions as possible.
Dec
3
awarded  Tumbleweed
Nov
26
awarded  Critic
Nov
26
comment How to recover a VMware virtual machine
If you're making a comment, please post a comment, not an answer
Nov
26
asked Host machine (win8) can't connect but guest (virtual win7) machine can