HI ALL , HAVE A GOOD TIME !

Please for help me with the line of VBA code
which if mycell in myrange value = TRUE , to
return me( 6 cells in right of this cell ,same row )
the name of current workbook .

Thanks very much for your time