View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Novice in exel macros needs help

Jere,

Try something like

Dim Rng As Range
Set Rng = Range("A1")
Do Until Rng.Value = ""
' do something with the data in Rng and that row
Set Rng = Rng(2,1)
Loop


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jere" wrote in
message
...
Hi,

I'm currently working on a project that consists of filing data

of lecture attendance. Now what we have, is an exel chart of all
the people who have attended any of the lectures, where, when,
how long was the lecture and which one was it. Now what I need to
do, is create a macro that will take the data from one line
[Name, company, lecture, date & time, length], and create a
certificate that uses the data that the particular line has.

The said list contains roughly about 100 names at this point,

and I think that manual typing one by one would be a pain. So I
was hoping that someone could tell me how I can get exel to
repeat the project for each line, untill it finds a line that
doesn't have data on it. Also, does anyone know if I can create a
macro that takes data from exel, and places it into a word file
in the spesific places I want it to be placed, and can it be
created as a self repeating process?

Thank you in advance for everyone who replys to this thread.
I'd also like to apologize for my poor grammar, but I'm not a

native speaker of English.

- Jere