All Issues
24,993 verified issues
Shortest Method To Reference A Single Row/Column of a Named Range in Excel?
I have a named range ( ) and I need to reference the first row and first column of that range within a formula. I came up with the following: First row: First column: This seems cumbersome, especially since the Excel object model exposes and in VBA. Is there a more concise way of expressing this?
Why is IP to MAC address translation needed?
On networks that use the TCP/IP protocol, why is the IP address translated into a MAC address? I mean, when every device knows its IP, why further use the MAC address and not use the IP number as the address directly?
Does this exist: a standardized way of documenting a file-system structure
At work, I'm in charge of maintaining the organization of a whole lot of varied data on a standard file-system. Part of this is coming up with sensible classification (by similarity, need, read/write access, etc), but the bigger part is actually documenting it: what documents/files/media should go …
How does one paste code into an Office Communicator conversation
Whenever you paste code into Office Communicator, it decides to convert half of your code into emoticons. I'd like to prevent this from happening, so the other side can read the code, and copy it as well. There is an option to turn off showing emoticons in your conversation window, but I don't thin…
How to convert exFAT to FAT32?
How to convert an exFAT-formatted USB flash drive to FAT32?
Internet Explorer doesn't remember SharePoint password on saving
I am connecting to a SharePoint hosted site outside of my intranet through Internet Explorer 8. While accessing the site, I am required to provide user name and password with an option to remember the password. If I select the remember password option, it doesn't seem to remember the password. It s…
How can I search and replace in multiple Word files?
I am looking for a way to do search and replace in many Word (.doc) files (for the purpose of automation of the process). The software I found so far only allows me to search, but not replace. How can I do that with Word?
User directory in PATH in zsh: ~ Does Not Work
I'm doing this in my .zshrc and if I do it appears as the first thing in the path. Yet this directory isn't included in the executable path (nor for tab-completion). What am I doing wrong? shows the directory as expected. Edit: This works, though... I guess doesn't work in the path?
Can't resolve localhost on Mac OS X Server
I have a server running OS X Server 10.5 and it can't resolve localhost to 127.0.0.1. When I try ping this is what happens: SSH and web browsers get similar results (uknown host). If I try using 127.0.0.1 or the ip address assigned on the LAN all of the above work. Here's the contents of my /etc/ho…
Install MySQL 5.5 on Ubuntu 10.04
How to install the MySQL 5.5 on Ubuntu 10.04? apt-get install mysql-server is only allows to install 5.1.41.3ubuntu12
Merging and sorting multiple files with "sort"
I have a bunch of text logfiles in the following format: The files are already sorted by timestamp. I need to get 1 log file with all the logs from multiple logs files, sorted by timestamp. Note that the log files are really huge, around 3-4G each (and there are dozens of them) I tried the followin…
How to change the default screen sharing / VNC port number on Mac OS X?
Is there any way to change it from the default to some other port?
Minimize writes to SSD disks with Windows 7
Most people use their SSD as their primary system installation disk with Windows 7. W7 already has a lot of optimizations for SSDs, both in terms of performance and lifetime. Minimizing writes increases the lifetime of SSDs, so post each suggestion as an answer and let others vote on them. Update: …
Ways to deduplicate files
I want to simply backup and archive the files on several machines. Unfortunately, the files have some large files that are the same file but stored differently on different machines. For instance, there may a few hundred photos that were copied from one computer to the other as an ad-hoc backup. No…
find command in Linux to locate pdf files
My goal is to find all pdf files on a remote machine, so I resort to the useful command . So I type or and I get nothing. I do the same on my machine and I get nothing. I do a regular search from the menu on my machine and I find quite a few pdf files. Would somebody please tell me what am I doing …
Is there any way to execute something when closing the laptop's lid?
I'm wondering if there is any way to execute a program, run some command or anything else when closing the laptop's lid. My question aims to be generic, both for Windows and Linux. Something useful should be locking the laptop when closing the lid (Win + L in windows), or running expensive processe…
How to open some location in new tab in existing nautilus window? (from console)
I want to type something in console that will open some location (on example home dir) in already opened nautilus window. Is it possible?
Bash Auto-complete Adds Trailing Slash After Filename
I recently upgraded my system from Etch to Lenny. Now when I use auto-complete, file names (not directories) appear with a trailing slash on the command line. It seems to be related to multiple (all?) commands. I tried a few: How do I fix this?
How to Load Balance 2 Internet Connections on a Windows 7 machine?
It's sort of related to this particular question, but that one is on Mac. I am looking for similar solution on Windows 7. I have 2 network connections: (Connection A) Wireless terminal connecting to ISP A (3G / EVDO internet provider) (Connection B) Broadband wired connection connecting to ISP B (C…
What is the § ± key for on Mac keyboards?
Some Apple keyboards have a key with § and ± symbols on it. Can somebody tell me what these keys are for, and where I should use them? I am aware the symbols have mathematical uses, but I assume they must do something important as well to be on the core keyboard. Or are they just the 'Scroll Lock' …