In a macro, I have a form (Bedding_Tag_Information) that has been filled out with sizes (bti_length, bti_width, and bti_thickness. These are the variables assigned to the numbers keyed into the form. When I click the "Done" button, I want to paste the values into sheet (body) and starting at range (body_poly). I then have a vlookup on the bti_thickness for a calculation. The cells on the sheet (body) are formatted as numbers, but when I use Activecell.Value = bti_thickness, the macro puts the correct number in the cell but changes the format. Then the vlookup returns the #N/A. Any help? Thanks.