IRrstuff,
Unfortunately this is not working because I am not able to stop the macro when the save as dialog box is open. My problem is to create a macro that only opens the "save as" dialog box.
What VSB language make it possible to open a "save as" dialog box when running the macro? Also a problem for me is, how to refer the default filename in the "save as" dialog box to a cell contents in the concerned worksheet? Thanks in advance for your help.
As part of a visual basic program I need to count the number of characters used in a cell. For example, if cell A1 in a workbook contains the text: How are you today?, the function or macro should give: function(A1) equals 15.
Thank yo in advance for your help.