Look for multiple columns which are blank

[Geodav]

Hello, my code only looks at Column A for a blank cell. However I want to check for example the columns from range A to M.
Maybe also someone has a better idea than I have: The excel list is within Sharepoint. Multiple people are accessing it. Is there a way to better check if a person is currently writing within a cell or selected it?
My Solution but nowhere near perfect, check if the cell is blank. Then copy paste. Would be greatful for suggestions, thank you!

Please Login or Register  to view this content.

[Geodav]

have a solution:

Please Login or Register  to view this content.