Blankhello Paul I came up against this question to in the e c d l course and asked the question and didn't get the answer I don't think its possible . maybe you will have better luck. regards Vincent ----- Original Message ----- From: Paul Halligan To: vicsireland@xxxxxxxxxxxxx Sent: Wednesday, October 01, 2008 11:47 AM Subject: [vicsireland] selecting alternate rows in excel hi folks in excel i want to select a range of cells, say from a2 to a7 and i also want to select the range c5 to c10 , in other words without doing anything to the b column. any help on this action? thanks aforehand Paul H