Last Cell
Posted by Roy Brunt on August 17, 2001 12:28 PM
OK then I will ask this another way:
If I have a worksheet with data in cells and formula in other cells, is there a way i can search the worksheet and identify the last cell on the worksheet that has data in it (but not a formula).
The cell formula in question only returns a value when needed and so the cell will show as blank when not needed but is still picked up when the worksheet is searched.
Please please help with this
Roy
Posted by phillip on August 17, 2001 12:33 PM
OK So somebody is FINALLY answering you ...
My suggestion is to be patient my son.
Or in other words.. don't be so 'BRUNT'
Posted by Mark W. on August 17, 2001 12:35 PM
Click on the Select All button located in the upper
left had corner of your worksheet where the row
(1,2,3...) and column (A,B,C...) headers meet.
Next, choose the Edit | Go To... | Special... menu
command. Select the "Constants" radio button and
press [ OK ]. Finally, press the Shift+Tab key.
The last cell containing data is now the active cell.
Posted by Ivan F Moala on August 17, 2001 9:49 PM
