kornie_jon
New Member
- Joined
- Nov 5, 2018
- Messages
- 2
Hello,
I have written some VBA code to copy cells from a "hidden" Sheet 3 when I click a "Form Controls" button on Sheet 2. Sheet 3 remains hidden, the information copies to the clipboard and I am able to past the information into Notepad or a blank Excel Workbook as a test. The problem is when I attempt to paste the information into a field within SharePoint, it will only paste if Sheet 3 is un-hidden when attempting to paste. Any ideas of what I can do to make this work?
<tbody>
</tbody>
I have written some VBA code to copy cells from a "hidden" Sheet 3 when I click a "Form Controls" button on Sheet 2. Sheet 3 remains hidden, the information copies to the clipboard and I am able to past the information into Notepad or a blank Excel Workbook as a test. The problem is when I attempt to paste the information into a field within SharePoint, it will only paste if Sheet 3 is un-hidden when attempting to paste. Any ideas of what I can do to make this work?
Sub Complete_Orders_button() Sheet3.Range("Complete_Orders").Copy End Sub |
<tbody>
</tbody>