Can someone please tell me how to select a range from the cell that I am in.
The cell will not be the same every time I run the macro. So I basically
want to select cells A14 to A20 one month and then the next month it will be
B14 to B20. So normally it would be:

Range (A14:A20).Select

But I plan on locating the first cell each month so that the next month when
I run the macro I will select the correct cell. But then I need to select
the other 6 cells underneath to. I thought it would be something like this:

Range("0, 0:7, 0").Select

But that is not working. Any help please?

Try,
Sub watch_it_grow()
Selection.Resize(7, 1).Select
End Sub

Mike


"carl" wrote:

Can someone please tell me how to select a range from the cell that I am in.
The cell will not be the same every time I run the macro. So I basically
want to select cells A14 to A20 one month and then the next month it will be
B14 to B20. So normally it would be:

Range (A14:A20).Select

But I plan on locating the first cell each month so that the next month when
I run the macro I will select the correct cell. But then I need to select
the other 6 cells underneath to. I thought it would be something like this:

Range("0, 0:7, 0").Select

But that is not working. Any help please?