You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

Ok, I am using VBA within Excel 2000 to write an application.This is what I am trying to do. Say that I have a cell with a string as a value such as 'MC,FG,ED,C,CFD". What I am trying to do is to ...