Not familiar with Lotus 1-2-3 but if "hold and fill" is like using the
fill handle then see
http://www.mvps.org/dmcritchie/excel/fillhand.htm-

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Stefi" wrote in message ...
Post your macro!
Stefi


"Annamalai" ezt írta:

I use macros by recording, not familiar with Visual Basics. I want to edit
the cell content of similar cells . When I run the macro on other cells it
takes the information from the very first cell and keeps repeating the info
on the first cell. What is wrong?
Is there any Excel short cut like Lotus 123, macro "?" to represent to "hold
and fill" while the macro is running.