How do I change the active cell in a non contiguous range or selection?

ptroiano

New Member

Join Date: Nov 2009

Posts: 1

8th Nov 2009

I know that "tab" "enter" etc change the active cell in a non contiguous range in the spreadsheet .
What I would like to do is have the macro do the same thing.

How do I get a macro to change the active cell in a non contiguous range or selection?

Thanks for any suggestions.
ptroiano

« Hide columns with certain coditions | userform - user selects image file from dir that will display in c »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
specify non-contiguous cell range as arguments to TTEST()	ttest_guy	Microsoft Excel Worksheet Functions	2	7th Feb 2010 03:58 PM
to change the macros as per active cell and range	pol	Microsoft Excel Misc	2	4th Aug 2009 01:19 PM
combobox selection to change cell range data	ryan.fitzpatrick3@safeway.com	Microsoft Excel Programming	1	20th Mar 2009 07:04 AM
pasting non-contiguous range of cells to new row, same cell locati	=?Utf-8?B?Tm90IGV4Y2VsbGluZyBhdCBtYWNyb3M=?=	Microsoft Excel New Users	3	4th Apr 2006 08:57 PM
Macro to change list box input range based on selection made in another cell	Sue	Microsoft Excel Programming	3	7th Oct 2004 06:45 PM