Variables in row...select statement

[Snap Happy]

Being rather new to VBA I can't seem to get a rows statement to work using a variable to define the row numbers.I have a variable [T1] which is the first row I want to select and a second variable [T2] which is the last row. The code i have used is...Rows([T1],[T2]).select -- Result - Application-defines or object-defined errorRows(T1,T2).select -- Result - Application-defines or object-defined errorRows("T1,T2").select -- Result - Type MismatchRows("T1:T2").select -- Result - Application-defines or object-defined errorRows(T1:T2).select -- Expected : list seperator or )Can anyone tell me what the syntax should be??????

 

[Ruddles]

Try:-

Rows([T1] & ":" & [T2]).select

 

[VoG]

Try

Rows(T1 & ":" & T2).Select

 

[Ruddles]

VBA variables! I thought they were cell references.

 

[Snap Happy]

Many thanks. Solution worked great.