Hi All,
I have an excel macro that is causing to typed content to change to default, so for example if I have entered something in italics, it would change it to normal once I press enter.
Can someone please let me know how I can change this macro to avoid this.
Please Login or Register to view this content.
You've got two:in your last line of code - perhaps that is causing your problem?Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Actually it is Autofit function that is causing this. What can I add in the autofit function below to stop defaulting to default font settings.
Please Login or Register to view this content.
Sorry tested again. Its not in AutofitRows(). Moreover, I have seen there are no two instances of Allowformattingcells in the last row. Any suggestions please.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Actually its application.enable events thats causing it. I have tested it thoroughly. Any idea how to overcome it without removing the use of Application.enableevents.
Is there code in any of the sheet modules or the ThisWorkbook module??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks