View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AlexJarvis AlexJarvis is offline
external usenet poster
 
Posts: 6
Default Dragging values down a range using a colum to determine its length

Is is possible to write a macro that drags values (or formuals) down a column
to the length of an adjacent column, like when you double click on little
square in the right corner of the box that indicates when a cell is selected?

For this question, I need the formula or data that is in the selected cell
to repeat for all cells in the adjacent column that have values. How do I do
this?