>>>For your first problem you have to set Fomat property to be "Text" before (not after) entering a value.
>>
>>Nadya, there is another - and slightly simpler - option: To put a single quotation mark in front of the text. Something like this:
>>
>>...Cells(nrow, ncol).Value = ['] + MyField
>
>Thanks, this worked.
>
>Unfortunately, I still don't know how to fire Record Macro option from Excel 2007 - could not find this menu option anywhere.
rtfm, perhaps that helps.
Fortunately for me <g>, I don't have Office 2007 installed on my computer.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)