Hello

Does anyone know how i can pass the range (location) of a cell into a variable eg row F5 into x. i have got this far but does not work, what is the correct syntax

x = xlap.ActiveCell.Range

thanks in advance