| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Itemize a colum and fill down
Hi,
I have a data range from A1:D10 Is there a macro to remove all data from column C, then itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? Note, the number of rows can change from 10 to any amount later. thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Itemize a colum and fill down
???
itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? -- Don Guillett Microsoft MVP Excel SalesAid Software "johncaleb" wrote in message ... Hi, I have a data range from A1:D10 Is there a macro to remove all data from column C, then itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? Note, the number of rows can change from 10 to any amount later. thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Itemize a colum and fill down
This should do it:
Sub tract() Dim sh As Worksheet, lr As Long Set sh = ActiveSheet lr = sh.Cells(Rows.Count, 1).End(xlUp).Row sh.Range("C1:C" & lr).ClearContents sh.Range("C1") = lr For i = 2 To lr sh.Cells(i, 3) = sh.Cells(i - 1, 3).Value - 1 Next End Sub "johncaleb" wrote in message ... Hi, I have a data range from A1:D10 Is there a macro to remove all data from column C, then itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? Note, the number of rows can change from 10 to any amount later. thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Itemize a colum and fill down
Don't you itemize down, Don? Lot's of people do that. Some do it starting
with one and work up, and others do it starting with a higher number and work down to one. "Don Guillett" wrote in message ... ??? itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? -- Don Guillett Microsoft MVP Excel SalesAid Software "johncaleb" wrote in message ... Hi, I have a data range from A1:D10 Is there a macro to remove all data from column C, then itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1? Note, the number of rows can change from 10 to any amount later. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill colum to the next non blank row | Excel Discussion (Misc queries) | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| VBA code to itemize range names and associations? | Excel Programming | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| lookup in colum a and compare values in colum b | Excel Worksheet Functions | |||
Linear Mode
