- Reaction score
Thanks for your quick reply Ian. I think it did the trick. I only tried one deletion and it worked correctly. Now to repair my recipes and finish deleting the duds.Hi opercularia. Had a chance to look at the recipe deletion problem.The recipes are grouped in sets of 10, it appears not to move recipe 11 to 10 correctly.
To fix the problem you need to get access to the "deleterecipe" macro how to do this depends on the Excel version.
You need to edit the deleterecipe macro, near the end of the macro you will see the following line
Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(39, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))
The 39 value needs to be changed to 46
Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(46, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))
then save the spreadsheet.
Hope that fixes trhe problem.
G'day Ian,Hi opercularia I am not at home atm, should be back in a few days and will look at the problem.
Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run.