Hi everyone.
I have a column - F6:F797 - with two lines of text (with a line break between them) in each cell. I need to apply italic to the first line of each one. I found this VBA code that does that, but needs adapting to serve my purpose. I'm no VBA savvy so I'd appreciate the help.
Credits to a SiddharthRout from Experts-Exchange forum.
Please Login or Register to view this content.
Thank you.
PR
Hi,
It appears all you need is to alter the range? If so
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you for the fast reply.
Forgot to ask: where do I paste this code in the VBA window?
PR
If you don't already have that code attached to a button (which is how it is intended), I would add it to a normal module in your workbook (Insert- Module in the VB Editor if you do not already have a module present) and make it public rather than private so you can run it from the macros dialog or assign it a shortcut key
Please Login or Register to view this content.
That's it. There's just one tiny issue - it's applying italic to the second line and not the first one.
Thank you.
PR
So it is! Perhaps this instead
Please Login or Register to view this content.
Perfect! You were most helpful. Thank you very much.
PR
You're welcome- it was my pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks