Selecting range of cells with variable row

[riggsd]

I need to be able to select a range of cells where the row number is a variable, endRow.

How do I select the cells from (endRow, 1) through (endRow, 5)?

If I knew the row, I could put something like, Range("A20:E20").Select, but I don't know how to modify that when the row numbers aren't known.

Thanks in advance.

 

[Von Pookie]

Try:

Range(Cells(endRow,1),cells(endRow,5)).Select

 

[Norie]

Try this.

Range("A" & endRow & ":E" & endRow).Select

By the way why are you selecting the cells?

 

[riggsd]

They're being selected because I need to merge them.

What I'm doing is automating some reports. The data in these rows comes out in one cell per row and needs to be merged in across columns A through E to follow the required format. Each report has a different number of these rows, hence the variable row number.

I'm trying Kristy's code since that's closer to what the rest of my stuff uses. So far, VBA is accepting it.

Thx.

 

[Norie]

You don't need to select ranges to work with them.

Range(Cells(endrow, 1), Cells(endrow, 5)).Merge

 

[riggsd]

Cool. Thanks again

 

[riggsd]

On a similar issue, how do I select rows using variables? I need to select the rows from startRow to endRow and move them to another worksheet.

 

[Von Pookie]

You should be able to refer to them like so:

Rows(StartRow & ":" & EndRow)