A simple one I hope:

I have a macro that is formatting a load of data, within the macro - i am trying to assign the row number of the current cell to a variable, for use at the end of each loop.

Any help would be ghreat - thanks.