always start in certain cell/row

Here are two range variables that contain the cells in columns A and H based on the active cell

Dim CellA As Range
Set CellA = Range(Cells(ActiveCell.Row, 1).Address)
Dim CellH As Range
Set CellH = Range(Cells(ActiveCell.Row, 8).Address)

Originally Posted by blane245

Here are two range variables that contain the cells in columns A and H based on the active cell

Dim CellA As Range
Set CellA = Range(Cells(ActiveCell.Row, 1).Address)
Dim CellH As Range
Set CellH = Range(Cells(ActiveCell.Row, 8).Address)

HI,

I am usnure as to how i should use the above... any tips?

Thanks

Antony