Posted to microsoft.public.excel.programming

ljb[_2_]

external usenet poster

Posts: 6

how to set activecell?

I have a worksheet_change event function that behaves differently based on a
value typed into a cell verses pasted into a cell. If I paste in a value the
activecell doesn't change. If I type a value and hit enter the activecell
moves down one row. How can I set the activecell to be the one I just moved
from?

thanks
LJB

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ActiveCell.FormulaR1C1	Rick	Excel Discussion (Misc queries)	3	March 28th 10 10:36 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
ActiveCell or ActiveSheet	Launchnet	Excel Worksheet Functions	1	July 20th 07 07:46 PM
ActiveCell in a Range?	Filo	Excel Discussion (Misc queries)	3	May 22nd 07 09:52 PM
Activecell problem	[email protected]	Excel Discussion (Misc queries)	1	October 26th 05 02:13 PM

All times are GMT +1. The time now is 11:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us