Please tell us in more detail how the layout of the data
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mary" wrote in message
...
I'm new to Excel macros and need to copy the entire rows for the range
from
the first through the last occurrence of "vacation" in column A. The
number
of rows will vary each month. Then I need to paste those rows onto Sheet1
in
cell A1.

I've tried using the macro recorder but not getting anywhere. Can you
help?

Thanks, Mary