View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gman[_3_] gman[_3_] is offline
external usenet poster
 
Posts: 2
Default Reselect cell after macro

Hi,
I have a range of cells used to input numbers 0 through 9. There are other cells that count the occurances of each number in that range (Count If 0, Count If 1, ...). After 20 entries a macro runs to copy/paste the quantity of each number ( # of 0's, # of 1's, # of 2's, ...) into 10 other cells.
Problem: How do I get Excel to reselect the cell that was selected before the macro ran? This cell could be any one in the data input range.
Any help would be greatly appreciated.