Thanks for the nice feature but I need your help please. The macro ends to an error at the same point every time!!!! ... .Range("D3:P18").CopyPicture .Paste ...... Any syggestions plese?
Hi and thanks for your comment. If another shape is selected it may not paste properly. What you can do is select the cell in which you want it pasted first. Try something like .Range("A1").select Add this before the paste line I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Randy, Please help me with a small issue when defining named-ranges. When I define a named range and deselect and select the range-address, the marching-ants around the defined range are not displayed. Also, when I select an already defined named-range from the list, it does not go to that range. This problem is only in one file that contains VBA code. I am using Excel 365. Please do reply.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the range and the formula so we understand the issue you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Thanks Mr Randy ! I am very grateful for the effort you have made.
For sure, you are very welcome and I am happy to help and share. Much appreciated
Thanks Randy for this amazing video.
For sure, you are very welcome Syed. I am happy to help and share
Thanks for the nice feature but I need your help please.
The macro ends to an error at the same point every time!!!!
...
.Range("D3:P18").CopyPicture
.Paste
......
Any syggestions plese?
Hi and thanks for your comment. If another shape is selected it may not paste properly. What you can do is select the cell in which you want it pasted first. Try something like
.Range("A1").select
Add this before the paste line
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Randy,
Please help me with a small issue when defining named-ranges. When I define a named range and deselect and select the range-address, the marching-ants around the defined range are not displayed. Also, when I select an already defined named-range from the list, it does not go to that range. This problem is only in one file that contains VBA code. I am using Excel 365. Please do reply.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the range and the formula so we understand the issue you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Thank you Randy! 🎉
For sure, you are very welcome and thank you so much for your continued support
Cool
Thank you so very much, I really appreciate that and so glad you enjoyed hte email