Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell as range
How can I make the code below refer to the current cell that is active?
Set rng = Range("A200") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell as range
set rng = activecell
-- HTH... Jim Thomlinson "Patrick Simonds" wrote: How can I make the code below refer to the current cell that is active? Set rng = Range("A200") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell as range
This did not work. I should add a little more explanation of what I want to
achieve. If the current active cell is A5 (R5C1), I need that to be the Range set for the other worksheets the macro cycles through. But the Range set needs to be what ever the active cell is at the time the macro is run. "Jim Thomlinson" wrote in message ... set rng = activecell -- HTH... Jim Thomlinson "Patrick Simonds" wrote: How can I make the code below refer to the current cell that is active? Set rng = Range("A200") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell as range
s = ActiveCell.Address
for each sh in Thisworkbook.Worksheets set rng = sh.Range(s) Next -- Regards, Tom Ogilvy "Patrick Simonds" wrote in message ... This did not work. I should add a little more explanation of what I want to achieve. If the current active cell is A5 (R5C1), I need that to be the Range set for the other worksheets the macro cycles through. But the Range set needs to be what ever the active cell is at the time the macro is run. "Jim Thomlinson" wrote in message ... set rng = activecell -- HTH... Jim Thomlinson "Patrick Simonds" wrote: How can I make the code below refer to the current cell that is active? Set rng = Range("A200") |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell as range
Thank you
"Tom Ogilvy" wrote in message ... s = ActiveCell.Address for each sh in Thisworkbook.Worksheets set rng = sh.Range(s) Next -- Regards, Tom Ogilvy "Patrick Simonds" wrote in message ... This did not work. I should add a little more explanation of what I want to achieve. If the current active cell is A5 (R5C1), I need that to be the Range set for the other worksheets the macro cycles through. But the Range set needs to be what ever the active cell is at the time the macro is run. "Jim Thomlinson" wrote in message ... set rng = activecell -- HTH... Jim Thomlinson "Patrick Simonds" wrote: How can I make the code below refer to the current cell that is active? Set rng = Range("A200") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use active cell to determine range | Excel Discussion (Misc queries) | |||
Clearly seeing active cell in a range | Excel Discussion (Misc queries) | |||
Verify Active Cell is within a Range that changes as cell is delet | Excel Programming | |||
find range name for active cell | Excel Programming | |||
Active cell is within a specific range | Excel Programming |