Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First row in Selection range (first index of a cell) EXCEL VBA
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 (VBA Code): .................... 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First row in Selection range (first index of a cell) EXCEL VBA
You want the first cell in the range? You can use .range("a1") of the range.
Here is a short example: Sub TestRange() Dim rng As Range Set rng = Range("a1", "d10") Debug.Print rng.Address Debug.Print rng.Range("a1").Address End Sub In the Immediate window shows: $A$1:$D$10 $A$1 Is that what you wanted? -- Kevin Vaughn " wrote: 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 (VBA Code): .................... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell range in Excel | Excel Discussion (Misc queries) | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |