Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last dirtied cell
HI,
I would like to know how to write the code that goes back to the last "dirtied" cell (i.e. the cell which I last typed data in before performing VBA to copy in a cell at the top of the worksheet). Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last dirtied cell
If you don't do any selecting in your code, won't it still be active?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "geebee" wrote in message ... HI, I would like to know how to write the code that goes back to the last "dirtied" cell (i.e. the cell which I last typed data in before performing VBA to copy in a cell at the top of the worksheet). Thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last dirtied cell
at the top of your procedure
set cell = ActiveCell then when you want to return application.Goto cell, true would be the best guess. -- Regards, Tom Ogilvy "geebee" wrote: HI, I would like to know how to write the code that goes back to the last "dirtied" cell (i.e. the cell which I last typed data in before performing VBA to copy in a cell at the top of the worksheet). Thanks in advance, geebee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last dirtied cell
here is an idea for you.
Sub test() dirty_cell = ActiveCell.Address 'then ' do stuff here 'at the end of your macro Range(dirty_cell).Select End Sub geebee wrote: HI, I would like to know how to write the code that goes back to the last "dirtied" cell (i.e. the cell which I last typed data in before performing VBA to copy in a cell at the top of the worksheet). Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |