Can you post some examples of what you have in one of these cell that
you want t the number of the cell reference changed in ?

Xis4Us wrote:
have a simple list that pulls from multiple worksheets within a
workbook. each cell in the list pulls from just one worksheet. the
list is structured so that the column from these worksheets does not
change but the row does. I go into each cell and change the number of
the cell reference. am trying to learn vba but could use a quick
answer on how to easily change the row number in these cells. thanx