I am trying to Copy from 1 workbook (S.xls) and pasting into (PD.xlsm) based on headings. However I also get the same error 1004- Application-defined or object-defined error at this line “lastCol = sh1.Cells(1, Columns.Count).End(xlToLeft).Column”

Hi have an excel workbook that I’ve been using for a few months, with several copy and paste buttons. Only recently have they stopped working after about 2 mins in of using excel all I get are these ��. When I load the spreadsheet they all work normally, but a while later they stop. Any advice?

Hi have an excel workbook that I’ve been using for a few months, with several copy and paste buttons. Only recently have they stopped working after about 2 mins in of using excel all I get are these ��. When I load the spreadsheet they all work normally, but a while later they stop. Any advice?

I’m hoping you could help me and point me in the right direction;
I’m currently working on a code that would help me to select and open to workbooks and copy the all the information in each workbook and paste into in the main workbook sheet called “Data”.
I looking for the search and open file option instead of the file folder location option so any user can search and select the workbook;
The current code is stopping when selecting the main workbook to activate and paste the copied data of the active woorkbook which is one of the two previously selected;

I have a range copied in memory.

What I am trying to do, is select multiple cells from an Excel file and paste the results in another program (for now lets say sticky notes or note pad). I plan on doing this with a VBA macro attached to a form control button. So clicking the button would select and copy, for example, cells b13:b29. That data could then be pasted into the target text editor. The cells being copied contain multiple types of data (plain text, numbers wrapped in the dollar() function, and concat() strings that include line breaks. I have the select/copy part of the macro worked out.

I’m new to VBA and after a half hour of combing the web, I haven’t found a solution. I’d like create a macro for Excel which will copy data with formatting from one cell to a destination that can be selected manually at run time. If someone could share a simple method, I’d appreciate it.
For example, in the embedded graphic, I want to create macros for each individual cell in A1, B1, C1 that will allow a user to select any cell in a single worksheet manually and use a ctrl+[letter] shortcut to paste the appropriate value into that cell. Many thanks in advance.