Dynamic Range.Select

[Ed S.]

I need a technique to .Select a range of cells that are based on stored column and row values.

Range("A1:Z10).Select is a "hard coded method and does not fit my needs.

I first position to the first cell and save the cell values using:
StartRow = ActiveCell.Row
StartCol = ActiveCell.Column

then, locate end cell and similarly save:
EndRow = ActiveCell.Row
EndCol = ActiveCell.Column

The results of save are:
StarRow = 1
StartCol = 1
EndRow = 10
EndCol = 26

These values define the points of my cell range.

How do I .Select this range? The following is close, but incomplete....

Range(Columns(SCol),Columns(ECol)).Select
*********************************************

 

[dk]

Hi,

How about:-

Range(Cells(startrow, startcol), Cells(endrow, endcol)).Select


Hope it helps,
D

 

[Russell Hauf]

On 2002-03-27 11:00, Ed S. wrote:
I need a technique to .Select a range of cells that are based on stored column and row values.

Range("A1:Z10).Select is a "hard coded method and does not fit my needs.

I first position to the first cell and save the cell values using:
StartRow = ActiveCell.Row
StartCol = ActiveCell.Column

then, locate end cell and similarly save:
EndRow = ActiveCell.Row
EndCol = ActiveCell.Column

The results of save are:
StarRow = 1
StartCol = 1
EndRow = 10
EndCol = 26

These values define the points of my cell range.

How do I .Select this range? The following is close, but incomplete....

Range(Columns(SCol),Columns(ECol)).Select
*********************************************

Range(Cells(StartRow, StartCol),Cells(EndRow, EndCol)).Select

Hope this helps,

Russell