I have a table which varies in length from 2 rows to 650 rows. There are
always 14 columns. I have a macro which formats the columns and adds a total
line to the last line of the table + 1. The columns have different formats,
so they need to be formatted one by one so using the macro is quicker and
easier. If I use RowNr = InputBox ("input the row number for the totals) in
the macro I can get the RowNr into the code, but how can I use it, Rownr, to
define a particular row or cell, please ?

Roger