Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

How to get an index of cell number in selction range.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mar_male@wp.pl - 20 Mar 2006 14:25 GMT
Hello,
I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.

I have something like this:
...................
Range1.Select
"and here I want to Select the first range in selection Range1"
............
I there any special function of finding first cell in selection range
or returning an index of the first cell??
Thanks for answet
Marcin
Dave Peterson - 20 Mar 2006 15:44 GMT
You have a response to your post in .excel

> Hello,
> I have a problem with selecting first cel in selection Range or return
[quoted text clipped - 9 lines]
> Thanks for answet
> Marcin

Signature

Dave Peterson

Tom Ogilvy - 20 Mar 2006 17:21 GMT
selection(1).Select

If you want to retain all the cells selected and make the first cell the
activecell

Selection(1).Activate

Signature

Regards,
Tom Ogilvy

> Hello,
> I have a problem with selecting first cel in selection Range or return
[quoted text clipped - 9 lines]
> Thanks for answet
> Marcin
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.