For some reason I can't use the following code in my application at work, when it's fine at home. (Older version of Excel and Windows at work)
Range("A1:A100").Find(What:="Test").EntireRow.Select
Anyone know why? The error I get is "Unable to use the Find property of the Range class".