1,285 reputation
31632
bio website blog.richardhartness.com
location Charlotte, NC
age 32
visits member for 2 years, 9 months
seen Apr 14 at 11:10

I am a software architect, living in Charlotte, NC.


Apr
14
comment How can I summarize age ranges and counts in Excel?
Excellent, the FREQUENCY function was what I was looking for.
Apr
2
comment Is there a way to synchronize my entire mailbox from Gmail, to Outlook 2011?
Thank you. I've already setup my account and I (should) be able to get new mail. However, I think I'm not downloading my old messages since they've been archived.
Mar
21
comment Is there a (reasonably easy) way to run word usage statistics on a document?
I tried to use it, bit states that it's an incompatible add-in. Odd.
Mar
21
comment Is there a (reasonably easy) way to run word usage statistics on a document?
@EBGreen, do you have a link? The only version of BullFighter that I can find is for office 2000 and XP. I'm using 2010 or 2011:Mac.
Oct
17
comment How do I modify user groups in Windows 8?
Thanks for this answer, and it certainly does get the job done with Pro. However, is there not a way to Navigate to this screen? Otherwise, I think it's a bit asinine of Microsoft to level this out!
Sep
5
comment Is there a way to move multiple tabs to a new browser window, in Chrome?
I see. Yes, I've been using a darker-blue theme for years. I guess that's the problem.
Sep
5
comment Is there a way to move multiple tabs to a new browser window, in Chrome?
Well, I feel like an idiot. I actually tried this, but since my tabs didn't appear to be highlighted, I assumed it wasn't working. Oh well. You already have 4 up-votes, I have 2 and someone commented that this "isn't possible". I guess this is a more common (failure of) observation than I would have initially thought.
Aug
30
comment Is there a way to print multiple worksheets into one document, with correct page numbers?
I know this is SuperUser (and code questions tend to belong on StackOverflow) but do you know how to do this in VBA? My users want a list box that they can use multi-select from the sections of the Excel document. This is actually a good requirement because there are a LOT of worksheets and mis-clicking, when selecting worksheets, is a very easy thing to do.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
That did it. Thank you!
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Aha! I see now. Thank you. Feel free to post an answer. After cutting on the Developer tab, I see that all I have to do is put the Worksheet in "Design Mode", much like Access and queries.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Unfortunately, no. This spreadsheet is worth a lot of money as a function, not just because of the data it is used to collect. I am positive there is nothing fancy going on (i.e. no special ActiveX controls.) Whatever was done to this spreadsheet was done using standard Excel 2010 tools and objects.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Apologies for my ignorance, the background for this spreadsheet was that it was created by a non-developer person, for a job that needed a MUCH more robust application. I'm writing the needed application but in the interim my users absolutely need some minor changes to the original spreadsheet. I've never used excel at this level and I'm a bit clueless as to how to do whatever needs to be done to make changes on my "switchboard" worksheet. I can change VBA code and forms, but this one form has me baffled.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
@mehow: I'm not sure and no, I don't have a developer tab open. All I can say is that these buttons are on my first worksheet, they are not on a VBA form, and they located within cells but appear to "float" over worksheet. How do I open a developer tab/toolbar?
Jul
12
comment how to determine which values in a given set of cells will add up to a numerical range
Oblig XKCD: xkcd.com/287 (Not exactly the same scenario but close enough.)
Jul
3
comment Where is /sys/bus/usb/devices on Mac OS X?
I haven't used libusb, but I did try to download it from Macports. It appears to have downloaded and installed properly. Try getting it through Macports and see if that helps.
Jul
2
comment Retina Macbook Pro Scaling
Related/Duplicate(?): superuser.com/questions/612492/…
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Actually, chuff's comment to David Yaw's post is what I am looking for. That will work too.
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
I understand now. I see that you have a solution. Let me see if there is a way that I can craft a conditional format that can highlight cells that have formulas in them.
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Day: No, when you go to show the formulas, it should shows all of the formulas for the entire worksheet, not just one cell. Is this not sufficient?
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Oh, I just noticed chuff's original comment. Control + ` (Backtick) is executing the menu command I'm referencing in my answer.