Rasoul,
There are a variety of loop structures available in VBA. For
example: For/Next, For Each/Next, Do While, and Do Until. See
on line help for more details or post back with a more specific
question.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Rasoul Khoshravan Azar" wrote in
message ...
In ordinary programming language like Basic we have a command
called "loop"
which is used for recurring a command or a series of commands
to reach a
criteria. How should it be done in Macro?
Specifically I want to cut and paste specified cells and then
do it again
for another cells.
Any help is highly appreciated.
TIA, Rasoul