Hello I have this issue. Before now my excel VBA was working fine before i had it it this form. The new form is where i invoked a sub into another sub. i ran this new code with hard coded values on the excel macros and it worked as separate subs. but then i am having issues passing parameters into them using the entry method parameter . it runs the first sub perfect with the parameters i passed but when it gets to the part where i call the child sub with the same parameter it throws some required argument error . I feel the child subs are not getting the arguments . please how do i do this. Find attached my macroFilterCopyPasteToNewSheet.txt (3.6 KB)
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil