Use a cell as the range in my VBA

[scassells]

Trying to use the contents of D% as my range when running the below MACRO. Not clear why the below will not work.

Sub TLANE_ERROR_Summary_Update()

' TLANE_ERROR_Summary_Update Macro


Call CLEARTLANE


Dim cl As Range


Dim myRange As Range


Set myRange = Range("D5")


For Each cl In Range(myRange.Select)


Sheets("TMODE_TLANE_PIR_HEALTH CHECK").Select


Range("H4") = cl


Call TMODE_TLANE_ERROR


Next cl


Call sortTLANE

Call Select_TLANE


End Sub

 

[scassells]

Actually I meant D5 not D%

 

[Norie]

If D5 contains a string that represents a range reference try this.

For Each cl In Range(myRange.Value)

 

[scassells]

Thanks this fixed the mistake in my code and revealed that the string was in D4 and not D5
Cheer!!