View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default loopig in Macro Programming

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