VBA: Refer to cell value in range

[jamescooper]

Instead of putting L2:L, I want to put the value in the workbook "Cards", worksheet "Data" and cell M2. What am I doing wrong below please?

Many thanks.

For Each URL In Range("L2:L&[Cards]Data!M2")

 

[Max1616]

I would do something like this:

Dim Cards As Workbook
Dim Data As Worksheet
Dim MyValue As Integer

Set Cards = ActiveWorkbook ' Change this to the cards workbook
Set Data = Cards.Sheets("Data")
MyValue = Data.Range("M2")

For Each URL In Range("L2:L" & MyValue)