From January 1994: the last issue of the last volume of Fleetway's RED DWARF SMEGAZINE: Volume 2, issue 9.
At least the publisher had the good grace to actually publish a finale. An extended 64-page goodbye no less. This was, no doubt, to ensure that all material commissioned and completed for issue 10 and beyond was actually published rather than written off when the license was dropped. Gone were the days when Marvel would tart up an old Tarzan tale as an issue of BATTLESTAR GALACTICA.
The cancellation wss probably down to the adult (and teens) property sitting uncomfortably in Fleetway's portfolio of titles pitched at a much younger audience. Its magazine/ comic hybrid status probably didn't help. That said, it's surprising that Marvel UK (who did, after all, grab THE GLAM METAL DETECTIVES) didn't add the property to their briefly booming line of licensed magazines.
RED DWARF continued on TV of course. Although I'm not a fan so I wasn't watching.