Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy Value listing code
Hey guys,
I dont know what I did but I lost this code. I need a code that will look in Range A4:Z4 and then list all the values of that range in cell A5:A1000. Thank you. Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy Value listing code
Sub dhjsa()
Dim cl As Object Dim i As Long i = 4 For Each cl In Sheets("a").Range("A4:Z4").Cells i = i + 1 Sheets("a").Range("A" & i) = cl.Value Next cl End Sub -----Original Message----- Hey guys, I dont know what I did but I lost this code. I need a code that will look in Range A4:Z4 and then list all the values of that range in cell A5:A1000. Thank you. Todd . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing all items only once | Excel Discussion (Misc queries) | |||
Title listing... | Excel Discussion (Misc queries) | |||
Easy VB code question | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel | |||
sum and listing | Excel Discussion (Misc queries) |