Copy comments to a new range of the same size (without using copy, paste)

Note that I'm not able to test, but this should work

Please Login or Register  to view this content.

Note that there number of problems in your code
1.As you have done it Arr is Array and holds just the values of the Range, not the respective Range object itself
2. Given 1 it does not have Comment property
3. You have On Error Resume Next which prevents you from actually seeing what the problem is
4. Unless you have Option Base =1, UBound will be 1 lower than you expect (by default array index is 0-based)
5. your loop is not the best one

Originally Posted by Jonathan78

I only had to insert the "on error resume next" line in because it throws an error message when there is no comment found.

The proper way to handle this is

Please Login or Register  to view this content.

Note that if you don't reset On Error Resume Next it will be in force to the end of the sub, so you will not see other errors in the following lines of code