setting range from activecell in macro
Hi,
I am trying to select a range of cells after selecting a cell based on an
activecell.offset. For example, a line in my code looks like this:
ActiveCell.Offset(2, -3).Select
Now I want to select a range of three cells (the selected cell and one cell
before and after the selected cell). The absolute location will not always be
the same, therefore can not select range based on absolute cell references
(i.e. A1:A3 or .cells(1,3),.cells(3,3) for example). Can't figure out how to
do it. Any help??
|