View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default "Move Several Cols Down One Row"

Howdy folks,

I have data in Cols A through F...about 6 to 7 thousand rows (varies). I'd
like to shift all data in Range B2 through F (LastRow) down one row. I know
I can do this with a copy/paste macro but was wondering if that is the best
way to accomplish this.

All comments appreciated,