Range inside cell reference

[Tablecloth98]

I'm trying to specify a range from L1 to Q where the row value of Q if specified by the value of a cell in another sheet (Let's say Worksheets("Sheet1").Range("N" & i)).

I've defined variable j as an integer and set it to equal Worksheets("Sheet1").Range("N" & i) however, when I try to use the variable j in a cell reference Range("L1:Q" & j) it returns a syntax error.

Does anybody know where I'm going wrong with this?

 

[Sektor]

Could you post a code? It should be something like that:

Dim j&
Dim rng As Range

j = Worksheets("Sheet1").Range("N" & i)
Set rng = Range("L1:Q" & j)

 

[Joe4]

Please post your VBA code so we can see it and check the syntax.
See here how to post your code: How to Post Your VBA Code

 

[Tablecloth98]

Sorry guys I've figured it out (I've been at it for hours ) I'd missed a bracket off further along the formula, then it came up with a type mismatch because the cell wasn't formatted as a number. Thank you for your responses though

 

[smozgur]

@Sektor provided the right solution for the text only question. Therefore, I marked it as the correct answer in order to help future readers.