Thread: Insert a fixed number of lines between a varying range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dschindler dschindler is offline
external usenet poster
  
Posts: 2
Default Insert a fixed number of lines between a varying range of cells
I am sent a continuous range of client IDs for a report every month that will
vary in length each month. In between each client ID I need to insert 6
empty rows. Does anyone know how this can be done through the use of a
macro? I don't know how to get excel to put 6 rows between each original
cell for the full range of data that will change each month. Any help would
be greatly appreciated
Reply With QuoteReply With Quote