Select rows using variable in second position

[dar149]

I am counting how many rows in a specific column contain data. Other columns may contain additional data, but I don't care about those rows, so I can't look for the end of a list. I am capturing the number of rows in a variable, say X. I am using the following code:
ActiveCell.Rows("1:X&quot.EntireRow.Select. I get a type mismatch. Any suggestions?

 

[xlbo]

ActiveCell.Rows("1:X&quot.EntireRow.Select
makes no sense
For a start, the activecell can only have the singular ROW as a property
you need to use
Rows("1:" & X ).entirerow.select Rgds
~Geoff~

 

[dar149]

Thanks!! It works great.