selecting range variable
Posted on 2013-06-05
i've got a function that is accepting a range argument. now i'm trying to select that range cell like range("A1").select action so that i can do offsets, etc and it would keep state by using selection.offset(1,0) etc.
how do i select a cell in excel by using this range variable?
rngStartingCell.select - and it returns an error
range(rngstartingcell).select - and it returns an error
sheets("graphs").rngstartingcell.select - and it returns an error
Function ClearCells(ByRef rngStartingCell As Range) --> this is the function definition
thanks guys in advance!!! = ))