Relative range using variable

[jnathan]

I am trying to get the following to work: (rowCount is my variable)

Range("L" & rowCount:"R" & rowcount).Select

but I am getting a Compile Error:Syntax Error.

Can anyone help me and let me know where I am going wrong with this?

Many thanks

J

 

[Rick Rothstein]

I am trying to get the following to work: (rowCount is my variable)

Range("L" & rowCount:"R" & rowcount).Select

but I am getting a Compile Error:Syntax Error.

Can anyone help me and let me know where I am going wrong with this?

The colon is text and must be included with the rest of the text constants (inside the quotes)...

Range("L" & rowCount & ":R" & rowCount).Select

 

[James Snyder]

Your colon needs to be within the quotes.

 

[jnathan]

Many thanks, Rick! I knew it was something like that but working late in the office means that the 'ol grey matter is slowing down.

Much appreciated!

J

The colon is text and must be included with the rest of the text constants (inside the quotes)...

Range("L" & rowCount & ":R" & rowCount).Select