Syntax issue
Thanks Jacob
"Jacob Skaria" wrote:
If you are passing the cell address ...that should be as a string like
Call Q20_DUMPDATA_UF0_QCP("A1")
Sub Q20_DUMPDATA_UF0_QCP(stage)
Set rng = F_LNCH.Range(stage)
'...statements
End Sub
but it looks like you are trying to pass a named range
Call Q20_DUMPDATA_UF0_QCP(check.refi)
Sub Q20_DUMPDATA_UF0_QCP(stage as Range)
'...statements
End Sub
--
If this post helps click Yes
---------------
Jacob Skaria
"Brett" wrote:
if "CHECK.REFI" is the name of a cell then how do I pass that to a sub please?
This doesn't work:
Call Q20_DUMPDATA_UF0_QCP("CHECK.REFI")
Sub Q20_DUMPDATA_UF0_QCP(stage)
Set rng = F_LNCH.Range(stage)
...statements
end sub
|