View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Reselect cell after macro

Hi one way:
sub foo()
Dim rng as range
set rng = activecell
....' your code
rng.select
end sub

Frank

gman wrote:
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.