How to use the column of a named range

[Upex]

Hi All,

I'm trying to replace a quoted column reference with reference to the column of a named range so if the column position changes it doesn't need the code updated, but cannot get anything I've tried to work...

I currently use:
sColumn = "J" (with sColumn dim as string)

and then use that later as part of variable ranges... Range(Range(sColumn & 3), Range(sColumn & Sheet1.Rows.Count).End(xlUp)) fashion.

Column J:J is named 'detail' so I'm trying to use something like:
sColumn = range("detail").column

but cannot get anything I've tried to work. Any ideas?

Thanks in advance!

 

[Joe4]

You are welcome.
Glad we were able to help!