Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range row Address.
Hi All,
I have a problem and here it is. For example I have selected a range i.e A10:A19 in excel. I want A10 as my start point and A19 as my end point in excel basically I want the start row number and the end row number so that I can write a procedure in VBA as mentioned below. Dim Spoint as integer Dim Epoint as integer Spoint = 10 Epoint = 19 I tried working around with the below mentioned code but I am not able come at a solution. ActiveWindow.RangeSelection.Address(False, False) Regards Heera |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
getting the absolute range address from a dynamic named range | Excel Programming | |||
Return Range Address from Active Range | Excel Programming | |||
select range and put range address in variable | Excel Programming | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) |