Function to list row height

This week I successfully tested a function which accurately shows the height of rows in Excel. I spot checked row heights dozen of times, and can confirm that it's accurate.

Press ALT + F11 to enter Visual Basic, and in the project list to the left right click on your worksheet and create a new module to enter this vba code in:

Function RowH(r As Range)

RowH = r.RowHeight

End Function

The vba code will allow you to enter a formula - RowH - that can reference a cell and return the number of points of the row height.

Note that the result will not automatically update when rows are re-sized.

Augmenting Excel Row Heights by a Set Value

Recently when editing a long spreadsheet in order to confirm that each row was wide enough to display all of the text inside a cell, I ran into some trouble beyond that posed by cells with too much text to fully display with the maximum row height of 409.5. While Excel's AutoFit Row Height tool on the Home tab usually sets most rows to the correct width, it will not infrequently cut off a line or two of text from rows with cells that contain more than a couple of thousand characters.

In order to address this problem, you can make use of the macro posted here, by Robin. The vba code is copied below.

This code, will augment each row that is specified in a range by a fixed amount that you designate. So if you want to increase rows 2 to 5 by 10 points enter 'rowRow.RowHeight + 10' at the end of the fourth line, and specify 2:5 in quotes in the In Rows parentheses on the third line.

Option Explicit

'v0.1.0

Sub sbChangeRowHeightMulti()

Application.ScreenUpdating = False

Dim rowRow As Range

For Each rowRow In Rows("2:5")

rowRow.RowHeight = rowRow.RowHeight + 10

Next rowRow

Application.ScreenUpdating = True

End Sub

More on RelativityOne's Staging Explorer

The Tip of the Night for September 23, 2021 discussed how to use Relativity Staging Explorer to upload and download data for RelativityOne, and tonight's tip provides some additional detail.

Staging Explorer is a great asset. It will transfer metadata without altering it, and can help you transfer more then 60 GB of data or more than 100,000 files in as little as an hour. It's possible to access Staging Explorer through the RDC . . . .

Staging Explorer has some limitations which you may run up against.

• Only one instances of Staging Explorer can run on a Windows operating system.

• You will need to have your firewall set to allow for outbound connections on particular ports. A connectivity check must always be performed before initiating a transfer in Staging Explorer. Access it through the drop down menu at the top right.

• Files with paths longer than 470 characters cannot be accessed.

• Staging Explorer will not let you mount an .iso image file from a disc.

• No more than 10 million files can be set to transfer at once.