Thread: reset lastcell
View Single Post
 
Old 01-08-2017, 12:58 AM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default reset lastcell
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
Reply With Quote