#Vba application#

i want to know with application.caller and parent.range ,somebody can explain abaut it with example how to use

A simple Google search ... https://msdn.microsoft.com/en-us/lib.../ff193687.aspx

You should find the answer to your other question somewhere there.