F Frank Kabel Mar 25, 2004 #2 Hi you could use the OnKey method for this. Have a look at the VBA help for this
G Gord Dibben Mar 25, 2004 #3 Newbie If you mean it takes you far beyond your actual used range, you can reset the range. Debra Dalgleish has instructions and pictures at.... http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben Excel MVP
Newbie If you mean it takes you far beyond your actual used range, you can reset the range. Debra Dalgleish has instructions and pictures at.... http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben Excel MVP