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 |
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 |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com