D
DLykins
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hi. I need to be able to have Applescript refer to a cell using a reference that is relative to the active cell. This would be in the (row, column) format to reference cells. An example in Visual Basic would be:
Do While ActiveCell <> ActiveCell.Offset(1, 0)
ActiveCell.Offset(1, 0).Select
Loop
The only thing I've been able to find uses absolute references (A1, B3, ...). I cannot use an absolute reference because I want to compare a value in a cell that is relative to the active cell and then move the active cell to another location and repeat the test with yet another cell that is relative to the new active cell.
Any help would be greatly appreciated.
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hi. I need to be able to have Applescript refer to a cell using a reference that is relative to the active cell. This would be in the (row, column) format to reference cells. An example in Visual Basic would be:
Do While ActiveCell <> ActiveCell.Offset(1, 0)
ActiveCell.Offset(1, 0).Select
Loop
The only thing I've been able to find uses absolute references (A1, B3, ...). I cannot use an absolute reference because I want to compare a value in a cell that is relative to the active cell and then move the active cell to another location and repeat the test with yet another cell that is relative to the new active cell.
Any help would be greatly appreciated.