Tablecloth98
New Member
- Joined
- Nov 15, 2023
- Messages
- 16
- Office Version
- 2021
- Platform
- Windows
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?
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?