PC Review


Reply
Thread Tools Rate Thread

create a macro to move one cell to the right w/o specifying range

 
 
P Schneider
Guest
Posts: n/a
 
      11th Nov 2008
I am trying to create a macro that moves the cell pointer one cell to the
right without specifying a range. Please help!
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      11th Nov 2008
Hi,

Your question is far from clear but maybe this

ActiveCell.Offset(, 1).Select

Mike

"P Schneider" wrote:

> I am trying to create a macro that moves the cell pointer one cell to the
> right without specifying a range. Please help!

 
Reply With Quote
 
UglyChicken
Guest
Posts: n/a
 
      11th Nov 2008
On Nov 12, 9:56*am, P Schneider <P
Schnei...@discussions.microsoft.com> wrote:
> I am trying to create a macro that moves the cell pointer one cell to the
> right without specifying a range. *Please help!


activecell.offset(0,1).select
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
New range overwrites other range in create sheet macro wcollatz Microsoft Excel Programming 1 25th May 2009 08:52 PM
New range overwrites other range in create sheet macro wcollatz Microsoft Excel Programming 1 25th May 2009 05:45 PM
macro to select range from active cell range name string aelbob Microsoft Excel Programming 2 14th Jul 2008 09:19 PM
Create a Macro to Range Cells, from the contents of another Cell. Denis Lory Microsoft Excel Programming 1 11th Apr 2008 10:16 AM
Create Macro to copy a formula to range of cell =?Utf-8?B?c3VtbWVy?= Microsoft Excel Programming 2 15th Jun 2007 04:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:30 AM.