Hey again,
I was wondering if there is a way to use a macro to copy a merged cell without the blank spaces at the end? I'm attaching an example worksheet and I need to have the user copy the value of cell H3 so they can paste it in a program without the spaces at the end caused by the merged cells.
Thanks everyone!
Will the user be doing a paste-special? In that case, the spaces will vanish on their own. Have you tried doing a simple copy onto the program? Are you getting any trailing spaces?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Simple answer ids to never use merged cells, they nearly always cause problems
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks