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
Printable View
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
x = xlap.ActiveCell.Range
.address
i have tried the above but it does not work instead i recieve the error
run time error 450
wrong number of arguments or invalid property assignment
do you think maybe my variable (x) needs to be something other than a string?
sorry i meant activecell.address