Named Range in Cells Property

[Apple1]

I named the column W as S_Date, and tired to use it in my VBA code. But it doesn't work. I know I can use the named range in Range Property, but it doesn't seem to work in Cells. How to solve this? Thank you

row1 = WS1.Cells(WS1.Rows.Count, Sheets("Template").Columns("<wbr>S_date")).End(xlUp).Row

 

[Jon von der Heyden]

Try:

Range("S_date").Column