Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
6 28 65
Newest
 Yearling
Impact
~1.3m people reached

Jan
23
comment Microsoft Excel – How to link or copy cells to a different worksheet on every nth row
@Martin, I had written it so that Sheet2 was the Summary, and Sheet1 was the Detail (I'll edit that into my answer). You'll have to play with the indexes to get them to work right, but I'm out of time to figure it out now. I'll be back on Sunday or Monday, and if you haven't solved it yet, I'll hammer the right numbers out.
Jan
23
revised Microsoft Excel – How to link or copy cells to a different worksheet on every nth row
edited tags
Jan
23
answered Microsoft Excel – How to link or copy cells to a different worksheet on every nth row
Jan
22
revised Unlocker tool (website dead?)
edited tags
Jan
20
revised Laptop de-crappifying
edited tags
Jan
20
revised batch convert htm files to pdf
edited tags
Jan
15
comment Protecting the formatting in Excel 2007
@JoshuaD, you can probably uncheck most of those options except for Format Cells. I don't have Excel2007 handy to tell you which ones matter.
Jan
15
comment Protecting the formatting in Excel 2007
Hmm, I just went and tested .Protect UserInterfaceOnly:=True in my app also, and saw that you're right it doesn't protect the formatting of the unlocked cells. It just allows my VBA code to modify locked cells. I'll delete my answer.
Jan
11
revised Windows 7 Copydialog
edited tags
Jan
6
comment Freeze row and columns in Excel (and the same time)
It allows him to scroll either horizontally or vertically and keep the applicable column or row in sight, so that in a large table he can always see the column AND row headers. Think BIG tables.
Dec
21
revised How to fix the IE8 favorites menu (little box icon)?
added 41 characters in body
Dec
21
asked How to fix the IE8 favorites menu (little box icon)?
Nov
17
revised Firefox addon for searching with different search engines
added 19 characters in body
Nov
16
answered Firefox addon for searching with different search engines
Nov
1
revised What is an excel formula that will return me the last row number of a cell within a range that contains specific data?
edited tags
Oct
27
answered SQL Server 2005 on laptop. Not sure if I can delete
Oct
27
revised Does a recursive disk-space-usage pie-chart web-page generator exist for Linux?
edited tags
Oct
22
revised What accessiblity software (screen readers) is for windows?
edited tags
Oct
22
comment How do you get the Mac-address of a Networking Card in Windows?
+1 That's works great also. Thanks.
Oct
22
accepted How do you get the Mac-address of a Networking Card in Windows?