The macro was working perfectly under 7.5 (7.5.3??) but very frustratingly it's now dead after a Libreoffice 7.6.0.3 upgrade, as are the many(!) instances / slight variants of this code through my sheet. Can someone please help me understand why the old code isn't valid anymore and give a suggestion how to repair it? (Ideally the macro should work under version 7.0 onwards for different machines.)
Sub Col_D_for_Y
sheet = ThisComponent.CurrentController.ActiveSheet
source = sheet.getCellRangeByName("D14:D32")
target = sheet.getCellRangeByName("L14")
sheet.copyRange(target.CellAddress, source.RangeAddress)
End Sub
The source = sheet.getCellRangeByName("D14:D32") code is highlighted
when the error message box pops up.
