Hi,
I have a range of information on the spreadsheet that needs to be copied/ pasted to a SharePoint site.

I have the code written to copy the range on the spreadsheet (A1:F200), then open the SharePoint site in data sheet view.

The part I'm stuck on is how to get the VBA to click on the cell to the right of the asterisk (see attached image), and paste the copied range.

Is it possible? If so, how?

Thanks for the help!
Sharepoint Cell.jpg