Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reselect cell after macro
Put in at the end of the macro:
Sheet1.Range("A1").Select Change Sheet and Cell reference as needed. Cheer -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reselect cell after macro
Frank
Works perfectly, thanks! This discussion group is an excellent and invaluable resource. ----- Frank Kabel wrote: ---- Hi one way sub foo( Dim rng as rang set rng = activecel ....' your cod rng.selec end su Fran gman wrote Hi I have a range of cells used to input numbers 0 through 9. There ar other cells that count the occurances of each number in that rang (Count If 0, Count If 1, ...). After 20 entries a macro runs t copy/paste the quantity of each number ( # of 0's, # of 1's, # o 2's, ...) into 10 other cells. Problem: How do I get Excel t reselect the cell that was selected before the macro ran? This cel could be any one in the data input range. Any help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |