store contents of entire column as string

[mpower87]

Hi everyone,

my vba skills are limited as i am just starting to learn, what i am trying to do is get my script to store contents of every cell in column H (separated by a new line) as a string.

this is so that i can then pass this string to a new outlook appointment.

that is, lets assume column H looks like this

H
1 Title
2 ITEM1
3 ITEM2
4 ITEM3
5 ITEM4
6 ITEM5
7 ITEM6
8 ITEM7

i would like ITEM1 and onwards down the column to be stored in one string

your help would be greatly appreciated.

[wamp]

Place attached code in a module
NOTE! a string it self does have a limit to number of characters, so if you have a LOT of items, you should concider another approach.

tip: if you're just starting to learn VBA, I suggest that you set a breakpoint at "Sub toClipboard" (F9)
then start the macro and hit F8 for each line of code. - Then you'll see what each line does and you will learn a lot. (you can even mouse over variables to see what their content is.)

Please Login or Register  to view this content.