i have recorded a macro in excel now i want it to use in the vb . i hav copy it from VBA in the excel . now plz tellme how to use that code in vb .