merge 2 columns

Hey guys i was wandering if you could help, i am trying to create a macro that merges two columns in excel.

i have this vba script

Please Login or Register  to view this content.

but it only works on row 2 and none of the others. The spread sheet can contain a variable amount of rows in these two columns so i created what i thought would work a range specifier.

Please Login or Register  to view this content.

but when i did that it didn't do anything. can anyone help.

thanks for the reply the script you gave seems to delete the H column before merge the data over to column G not sure why though.

Hey thanks for the help i guess i don't understand.. as the macro works but seems to erase all the data that was in column H except for H1. The thing is they both have data the i need but G2 may be empty but H2 would not be and vise versa

Not between the data that those two hold. They share the same type of data just one shows outgoing and another incoming so i was trying to merge them so that i had one column incoming and outgoing together. and yes then i want to delete the leftover column.

ok thanks.