Thread: Quick VB Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
April April is offline
external usenet poster
 
Posts: 6
Default Quick VB Help

I need help writing some vb script.... I know that it is
not that hard, I am just having a brain freeze today and
need help. Here is what I have... In Column A, every
couple of rows I have a "Identifier" then a couple of
rows of names (Column B) and I need to write code that
will Start at A2 (Or Active Cell) and Do a Select
(xlDown), Offset (-1,0) (Up one Row) and CopyDown, then
select then next identifier and do it again until the
end. For example, Cell A2 to A4 will copy down what is in
A2, A5 to A26 will copy down what is on A5, A27 to A47
will copy down what is in A27.

Thanks, April