| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to cells by cells(0,1) etc rather than "A1"
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.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Do mighty exchange "pixels" on "mm" - cells (width, height)? :( | Excel Programming | |||
| Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Threaded Mode
