In general, any I/O pins can be used for CE and CSN.
I have been trying (successfully) to get the nRF24 to work with an Attiny alongside a DRV8833 DC motor driver which requires 2 PWM pins, a Serial output pin and an interrupt pin, and of course, SPI for uploading code. It needs careful allocation of pins 
...R