Hi all,
I am new to VBA and have been looking at the tutorials on here which has been great. I am still very novice so sorry if this is a very simple basic question.
Here is a bit of background of my issue
I currently have formulated text over several cells based on decisions users make in other field. I originally had all the text within 1 cell, but realised when this copies and pastes into a notepad or to an article, it comes out as 1 complete sentence and not paragraphs. It was easier to put these into their own seperate cells and use VBA to copy and paste. Example:
A1 - Part 1 of sentence
A2 - Blank
A3 - Part 2 of sentence
A4 - Blank
A5 - Part 3 of sentence
etc...
The reason I done it this way as well was when I placed it underneath each other (A1, A2 both having sentences) - They didn't have the correct character spacing.
I've also noticed, by doing it the way I have done in the above I get the table type look when I copy this into word which is not what I require.
My Issue
What I am trying to do is be able to copy the cell is A1 and apply bold character around it.
Have a spacing in between (char10 or char13) and then copy A3, copy A5.
The user can then paste all of this into the article they require... Currently being new, I do not quite understand how to do that...
I am thinking it is to put these each in their own memory and then retrieve all of this to copy?
Is there any guidance on if this is possible? Can anyone provide any tips on either how to write this or point me to a tutorial (if you know any of what I am trying to achieve) - I feel I know how to go about copying each cell and doing what is required.. but I don't know how to group up all that I have copied to paste in whatever I chose to do to each particular cell when I initially copied.
I hope the above makes sense
Bookmarks