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

  • Thread starter Thread starter mar_male
  • Start date Start date
M

mar_male

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
 
You have a response to your post in .excel

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
Click to expand...
 
selection(1).Select

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

Selection(1).Activate
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First row in Selection range (first index of a cell) EXCEL VBA 1
First row in Selection range (first index of a cell) 1
VBA set thick borders around non empty cells in range 0
First row in Selection range (first index of a cell) EXCEL VBA 1
Macro needs updated Range name addresses 3
Find method 3
Getting row indexes on Range 4
delete unused rows 2

Back
Top