Select range

[haseft]

hi!

want to select range between activecell and a cell with name.
get syntax error

Dim n As String
n = ActiveCell.Name.Name
ActiveSheet.Range((ActiveCell), Range(n + "sist")).Select
Selection.Cut

help please,

 

[WassimN]

Hi haseft

Can you use the Rows() and /or COLUMNS() Functions to get the row and column of the cell with name and then use that to select?

If the name a named range, or the cell content is a name?

 

[haseft]

A correction:
actually I want to select rows between activecell and the row with Range(n + "sist")

Dim n As String
Dim r1 As Long
Dim r2 As Long

n = ActiveCell.Name.Name
r1 = ActiveCell.Row

ActiveSheet.Range(n + "sist").Select
r2 = ActiveCell.Row

Range(r1:r2).Select
Selection.Cut