Note that will it not always be possible to access a virtual private network when using wifi in a public space. The admin of the network may have it configured to bar VPN protocols. This came up for me today in the Minnesota state district court in the Hennepin County Government Building in downtown Minneapolis. The speed of the wifi network in a courtroom was great (more than 50 mbs per second for uploads and downloads), but it would not allow me to connect to my firm's network via VMWare. I got around the problem by getting online with a MIFI device, which connects to the web using a cellular network.

26 views0 comments

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.

9 views0 comments

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


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

33 views0 comments

Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.


All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.


This policy is subject to change at any time.