excel - VBA With obj - how to reference the obj inside the With without naming it? -

excel - VBA With obj - how to reference the obj inside the With without naming it? -

if within block referencing object want reference function phone call illustration , must reference object name or there "this" ,"me" ref can use?

i have done search online not finding much in vba.

dim shexport worksheet shexport ....... ....... 'works expected getdata(shexport) 'but how can achieved without naming getdata(this) getdata(me) getdata() ........ end function getdata(sh worksheet) integer ..... ..... end function

you specify property of object supports .parent property reference object. example:

with shexport getdata(.cells.parent) end

excel vba excel-vba