Hi,
I can't work out how to split a worksheet at a particular cell. The Worksheet.FreezePanes method takes a cell plus row and column counts as arguments, however, the Worksheet.Split method doesn't take any arguments. Is there a way I can specify the cell to split at, or is the default split option (where it splits approximately in the middle of what I can see of the worksheet when I open it) the only option?
Thanks,
Shandos Cleaver