Prev: data file size increase
Next: Macro help
From: johncaleb on 10 May 2010 15:47
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.


From: Don Guillett on 10 May 2010 16:12
???
itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1?


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"johncaleb" <johncaleb(a)discussions.microsoft.com> wrote in message
news:D1D8BDDC-D1AC-450A-B3EE-6B92B00AFFE8(a)microsoft.com...
> 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.
>
>

From: JLGWhiz on 10 May 2010 16:27
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" <johncaleb(a)discussions.microsoft.com> wrote in message
news:D1D8BDDC-D1AC-450A-B3EE-6B92B00AFFE8(a)microsoft.com...
> 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.
>
>


From: JLGWhiz on 10 May 2010 17:05
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" <dguillett1(a)gmail.com> wrote in message
news:%23cisq0H8KHA.1436(a)TK2MSFTNGP06.phx.gbl...
> ???
> itemize down "10,9,8,7,6,5,4,3,2,1" starting at C1?
>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett(a)gmail.com
> "johncaleb" <johncaleb(a)discussions.microsoft.com> wrote in message
> news:D1D8BDDC-D1AC-450A-B3EE-6B92B00AFFE8(a)microsoft.com...
>> 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.
>>
>>
>


 | 
Pages: 1
Prev: data file size increase
Next: Macro help