Hi,

I tried but didn't find this answer. I need a macro in a cell of Sheet1 to be copied over to Sheet2 as the user enters information. But it doesn't stop there, it also has to convert the information. ie, if the user enters 20, then this must be converted to a string of "medium".

I tried this, but it didn't do anything
wkbSheet2.Range("F" & rowCt).Value = wkbSheet.Range("F" & rowCt).Value


THanks