316 reputation
110
bio website zlionsfan.blogspot.com
location Indiana
age 47
visits member for 4 years, 6 months
seen Dec 11 at 21:29
Software engineer/part-time DBA, mostly using ColdFusion, SQL Server, and VBA, slowly learning Flex. I use Eclipse for development (CFEclipse and Flex Builder).

Jan
14
awarded  Revival
Jul
23
awarded  Caucus
Aug
26
answered How to set zoom in an Excel spreadsheet embedded on a Word document to 100%?
Aug
26
awarded  Commentator
Aug
26
comment How do I generate 300 lists of 12 numbers between 1 and 33 without repeats in excel
This doesn't address the requirement that each prototype must appear 100 times. If you're going to write a macro to delete cells, you'd be better off writing a proc that generates the lists and checks them in the first place.
Aug
26
comment How do I generate 300 lists of 12 numbers between 1 and 33 without repeats in excel
it's actually not difficult at all in VBA.
Aug
24
answered Regex in excel: Fixing dates, from Apr 1/11 to 1-Apr-11
Aug
17
comment How to disable Wii updates through router filtering?
If the idea were to completely block access, it'd be simpler just to clear the wireless setup on the Wii itself.
Aug
15
awarded  Excavator
Aug
5
comment Move FF “Find Toolbar” to top
looks like you're missing the last s from that URL: find-toolbar-tweaks.
Jul
28
comment Color Cell Based On Text Value
Each condition still has to be created manually, even though they only need to be created a single time for the entire workbook. He's looking for a solution that doesn't require him to specify the values.
Jul
27
comment Color Cell Based On Text Value
Isn't this still going to require that the OP manually create a conditional format for each value?
Jul
22
answered In Microsoft Excel, how do you determine middle and end characters in these values?
Jul
22
comment In Microsoft Excel, how do you determine middle and end characters in these values?
@Kevin, to ensure that leading zeros are preserved, you would also have to mark the columns as Text.
Jul
21
awarded  Yearling
Jul
21
answered Get rid of undocking tabs in Firefox?
Jul
20
answered How to format an excel cell as a year, month?
Jul
18
revised Get last successful boot time from a Windows hard drive
fixed spelling and grammar
Jul
18
suggested approved edit on Get last successful boot time from a Windows hard drive
Jul
14
awarded  Critic