i'm trying to make use of the pastespecial operation in excel to copy the contents of a couple of cells, merge the cells and then paste the combined contents into the merged single cell. however each time the program gets to the point of pasting, it comes up with a "pastespecial method of...
Hi ,
I'm trying to write a macro in excel that'll read the contents in a particular column of a spreadsheet and seperate the contents into a new worksheet. What I mean is,
say the field, column G in the spreadsheet, has the contents as follows: "25 Dolemite Way, Manchester, England"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.