Excel: Removing Blank Rows

Excel has a powerful filtering capability that lets you view, among other options, the data without blank rows. But how do you remove the blank rows from your data? The following VBA code does the following:

1. Select a cell in the maximum row
2. Check if the selection is blank
3. Delete if blank
4. Move up 1 cell

      Dim x As Integer
      ' Set numrows = number of rows of data.
      NumRows = 1400 -2
      ' Select max cell
      Range("B1400").Select
      ' Establish "For" loop to loop "numrows" number of times.
      For x = 1 To NumRows
         ' Insert your code here.
         If Selection.Text = "" Then
            Selection.EntireRow.Delete
         End If
         ' Selects cell down 1 row from active cell.
         ActiveCell.Offset(-1, 0).Select

There is probably a smarter way to select the maximum number of rows, but for my data it was fixed.

Bathroom Documentation Confusion

I went out to lunch the other day and the restaurant had a confusin sign on the door to the bathrooms:

Sometimes there is just nothing to say. I mean, what is this?

Am I only allowed in the bathroom if I am a peeping Tom? Are the women here so beautiful that I would climb over a wall to see them? Or are they so ugly that I would climb over a wall to get away?

Check that Font

There is a website that lets you see your own custom text in every font that is on your computer. Just go to this website:

http://www.wordmark.it/

[Source Cybertext]

AIT: Book Properties in Word

I can never find the link in the AIT knowledge base to the list of the book properties along with the corresponding Word document properties. Here they are:

• the Title property stores the information in the Title field
• the Super title property stores the information in the Subject field
• the Version property stores the information in the Keywords field, and
• the By line property stores the information in the Author field. 

[source AIT KC]

AIT: Removing a Topic from a Version of a Book with Variants

Author-it 5.5 provides a greatly enhanced variant capability. It adds a hierarchy to the variants, which allow it to manage different versions of a book. As an example, we use the variant "designRev" with the following values:

A0

--> A1

    --> A2

This hierarchy allows us to create a book with versions A0, A1, or A2. But, what happens when I add a new topic to version A2? If I put it in the book TOC, then it will show up in versions A1 and A0 as well. 

To solve this problem, follow these steps:

1. Locate the topic in the library.
2. Right click on it.
3. Choose Variant --> Convert to Variant
4. Select the checkbox next to designRev and then click the checkbox for A2 beneath it.

Now, open the book and select A2 from the variant filter. The topic is shown in the TOC. If you select A0 or A1 from the variant filter, the topic is still in the TOC, but it has a strike-through and will not appear in the output.