Hello
I was wondering if there was anyway that I can shorten my following code or remove unneeded code,
Please Login or Register to view this content.
Hello
I was wondering if there was anyway that I can shorten my following code or remove unneeded code,
Please Login or Register to view this content.
Last edited by Jesus166; 12-17-2020 at 03:18 PM.
I just attached the Excel file , but basically it copies cells from the cover page to paste them on a refence page that we send to a coworker to file on a data base.
I get the procedure too large issue, but on my old excel sheet it works perfectly and the only thing I added to the current one is a few extra cells that needed to be copied.
Thanks' for the help, hopefully that will be a good start.
Quickest & easiest way is likeYou can also do a direct copy values likePlease Login or Register to view this content.
Please Login or Register to view this content.
I will try them when I get to work tomorrow
Based on the "20200.txt" file.
I didn't check the "xls" file.
There may be bugs.
Ps.: Code in the "txt" file - forum firewall blocks code pasted directly ... : ( ?!
Last edited by mjr veverka; 12-17-2020 at 08:29 PM.
.
*** IGNORE -- I did not see you posted a file until now ***
Last edited by Rick Rothstein; 12-18-2020 at 12:38 AM.
Hi Jesus166,
Try the below code & see if this does what you need ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks