I have numerous references from 1 sheet(report) to another sheet(photos).
Currently i use a simple but time consuming:
=IF(Report!C28="","",Report!C28) method.

I would like to code this as somehting like:
=if(Report!(3, 28)<"",Report!(3,28).

I have found due to an added delete row code i have put to the Report page
the cells being referenced to in the Photo's page then
change to Ref#(being not valid)
I am thinking that if i refernce the cells by code with the cells (x,y)
would auto fix the deleting of the rows in sheet 1??

Am i correct in saying this?
Can anyone assist me?

Corey....