View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default What is this Macro Doing? Please

This is a loop statement. Further down in the code there should be "LOOP".
In the first line, it states to loop as long as the cell value is not blank.
The next couple of lines simply set variables. The variables set to cell
addresses.

HTH,
Paul

"HERNAN" wrote in message
...
Please does anybody knows what is this for? What is doing?

Do While ActiveCell.Value< ""
beginaddrs=ActiveCell.Address
endaddrs=ActiveCell.offset(0,35).Address
Application.ScreenUpdating=True

Thank you!!