FYI -- I have done a fair amount of VBA but this is my first foray int
excel.

I have a workbook with N sheets (1-5). Each sheet has a differen
number of rows. Column A has a number. I want to toggle the inden
level of Column B on all rows on all sheets to the value found i
Column A or to 0. I assume I can do this in a subprogram fired from
macro -- maybe use a global variable to hold the indent on/off state s
the subprogram knows what to do.

What's the best way to loop over the data containing rows on each shee
and set this value? Setting the value is obviously easy but I haven'
been able to figure out loop parameters, etc. to make this go.

Any help or direction would be greatly appreciated! Thanks

--
Message posted from http://www.ExcelForum.com