I need a macro that will paste 2 rows of 6 values, copied from a webpage, into cells A1 to F2 of my worksheet. I can do it manually, but when I try to put it into a macro it pastes the data but then gives me an error saying the paste method is not valid???
Thanks for the help.