Automatically define Range

[jordan2322]

Hi guys,

I need a way to automatically look at a given worksheet in Column A for a Top Border, then go to the next row until a Bottom border is found and define that range to Column H as the value found in the Upper Left cell minus any spaces that cell contains

Cheers