View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default What is this Macro Doing? Please

You haven't shown us all of the macro. A 'Do While' loop always has an End
statement associated with it and you haven't shown all the code down to that
point.

What you have shown us 'translates' to

As long as the currently active (selected) cell contains something
assign the variable named beginaddrs the address of that currently active
cell and
assign the variable named endaddrs the address of the cell that is 35
columns over to the right of the active cell and
turn the updating of the screen back on so that any changes that occur can
be seen

So, if the currently active cell is A1, beginaddrs would contain $A$1 and
endaddrs would contain $AJ$1
These could be used for lots of things such as a range to copy or delete or
alter some properties such as cell background color or font style, color,
etc. Without seeing the rest of the code, no way to determine what happens
after the two addresses are obtained.


"HERNAN" wrote:

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!!