Here is my dilemma. I can do VBA in Access, but for some reason I just
don't get it in excel. What I want to do is go down a column and store
that info in a variable. I want this to happen untill there is no more
data. Once I have that data I want to go to another page and store the
data in an empty column. I want the program to auto. find the empty
column. Thank You in advance.
theguz


--
theguz
------------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918
View this thread: http://www.excelforum.com/showthread...hreadid=392941

Try

Do Until ActiveCell=""
'Put your store statement in between the "Do" & Activecell.offset
statement
ActiveCell.Offset(0,1).Select
Loop

"theguz" wrote:


Here is my dilemma. I can do VBA in Access, but for some reason I just
don't get it in excel. What I want to do is go down a column and store
that info in a variable. I want this to happen untill there is no more
data. Once I have that data I want to go to another page and store the
data in an empty column. I want the program to auto. find the empty
column. Thank You in advance.
theguz


--
theguz
------------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918
View this thread: http://www.excelforum.com/showthread...hreadid=392941

A similar way to do it is:

i = 0
While Not IsEmpty(Range("A1").Offset(i, 0))
i = i + 1
Wend



*** Sent via Developersdex http://www.developersdex.com ***