Hi I have an excel sheet I am managing from visual basic 6
I am updating the cells by cutting data from a web page and the pasting into the cells. The thing is I have to copy and paste several items so I have to kep switching back and forth between excel and the web page for each item.
Is there a way to Stack multiple items unto the windows clipboard then paste the items to the different cells in the spreadsheet?

Any help would be greatly appreciated

I am using the following code to paste the copied data into excel just for example