Code selects entire rows upto one range and same code selects only columns for other.

Hi

I am stuck up with a problem. I have used some of the code I got from this forum. In the excel sheet attached there are two set of ranges ...range named 45 and the range named 25. If if run this code...for the range 45, the codes shifts the entire range. and for the range 25..it selects only the column. I want to shift entire range as it happens for range 45. Kindly help.

Code goes like this

Please Login or Register  to view this content.