Search:

This article in PC magazine, about "CloudMark" (free) sounds pretty good.
I have not tried it.
http://www.pcmag.com/article2/0,2817,2385203,00.asp

'---
Jim Cone
Portland, Oregon USA ....

ActiveChart.SeriesCollection(1).Points(1).Border.LineStyle = xlContinuous
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Calculate Payments XL add-in: amount,...

See attachment...
Data sorted by name
Data subtotaled by volume
Groups with zero total - delete
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and...

Just sort the data by column C (volumes), then delete.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(XL Companion add-in: compares, matches, counts, lists,...

Chip Pearson has code to create a folder/file listing here...
http://www.cpearson.com/excel/FolderTree.aspx
You could create two separate lists and copy/paste both of them on a new sheet.

There...

Could be that the sheet name(s) doesn't exist or the Pub_ workbook is not open.
Also, I recommend using "Color" not "ColorIndex" to define colors in xl2007 and later: .Tab.Color

'---
Jim...

You might to also try this flavor...

Range("C5").Activate
Do While Not IsEmpty(ActiveCell)
If ActiveCell.Value = "Blank" Then
ActiveCell.EntireRow.Delete
Else
...

See your other identical post in Spreadsheets.

When deleting items from a collection, the general rule is to delete from the end back to the beginning. This modified version of your existing code, however does delete without problems...
'---...

Maybe too many styles? This free add-in (Formats & Styles) can list or remove them...
http://excelusergroup.org/media/p/4861.aspx
(about 1100 downloads)
'---
Jim Cone
Portland, Oregon USA ...

Big Round Button | Excel Options (button) | Popular (on left side top) | Include this many sheets: (spin button)
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware ...

I deleted the blank rows on your attached file and ended up with 40 rows with data.
I don't know how that compares to what you expected.

On your original data, I would just sort the data - blank...

http://www.scmagazineus.com/adobe-advises-of-flash-flaw-exploited-via-excel-docs/article/198312/
"Adobe advises of Flash flaw exploited via Excel docs"

According to the the article a patch is due...

Private Sub ComboBox1_DropButtonClick()

'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Lottery Numbers.xls - in the free folder)

RowStart and FinalRow are evaluated once by Excel at the start of the loop.
The RowStart and FinalRow values are not reevaluated during the loop.
You will get uncertain results by trying the...

I just had a similar experience with xl2007 and windowsXP.
What fixed the problem was deleting the .xlb file that contains the menubar/toolbars (or ribbon) configuration.
The file is automatically...

Kweaver:
To get possible winning numbers for the MegaMillions game or six other national/regional lotteries, my "Lottery Numbers" Excel workbook free download is here......

For what it is worth, the Microsoft xlsclean.exe download that was recommended only does a partial clean. It removes all content from the unused rows at the bottom of a sheet, but does not clear the...

Something simple...
Enter a zero for no renewal, enter 1 for renewal.
Sort ascending by forecast percent.
Count the number of zeros in the bottom half vs. the top half.

Or almost a simple......

You could use a dynamic range that self adjusts...
Example... http://www.contextures.com/xlNames01.html#Dynamic
''---
Jim Cone
Portland, Oregon USA
30 + ways to sort in excel

Maybe...

Function GetSpecialFolders(ByRef vFolder As Variant) As String
Dim WSHShell As Object
Set WSHShell = CreateObject("WScript.Shell")
GetSpecialFolders =...

Re Office 2000: be careful what you wish for. <g>

Excel prints selections on separate pages.
Have your co-worker copy and paste the two selections on a separate sheet and print that sheet.
'--...

Sub GetAddedUp()
Dim LastRow As Long
LastRow = Application.WorksheetFunction.Max _
(Cells(Rows.Count, 9).End(xlUp).Row, _
Cells(Rows.Count, 10).End(xlUp).Row)

...

I can't duplicate your problem with Firefox 3.5.11 on WindowsXP SP3.
I just tried this ebay item: Some software
Firefox gave me a separate window when I clicked "enlarge".
'--
Jim Cone
Portland...

You can paste the data into Word and use Format | Columns
or
try to find a third party utility/add-in to arrange the columns in Excel.
'--
Jim Cone
Portland Oregon USA
Special Print (Side by...