reset lastcell

[trevorc]

Hi again,
Is it possible to reset the lastcell value. ('Ctrl+End') selects last cell or Specialcells.lastcell

IE If I have data in say D100 and then data in D200



And then delete the data in D200, How can I make the lastcell now equal to D100 in stead of D200 ?

Regards
Trevor

[jeffreybrown]

Hi Trevor,

Try this...

Making the activecell the LastCell

[trevorc]

Thanks, just what I needed...