Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VisibleRange addresses to Array
Does anyone know of a way to input the address of each cell in the
visible range (I've been using ActiveWindow.VisibleRange as a test) into an array? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VisibleRange addresses to Array
Sub liminal()
n = ActiveWindow.VisibleRange.Count Dim ar() As String ReDim ar(n) As String i = 0 For Each r In ActiveWindow.VisibleRange ar(i) = r.Address i = i + 1 Next End Sub -- Gary''s Student - gsnu2007i "Giff" wrote: Does anyone know of a way to input the address of each cell in the visible range (I've been using ActiveWindow.VisibleRange as a test) into an array? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VisibleRange addresses to Array
Dim aryAddresses As Variant
aryAddresses = ActiveWindow.VisibleRange.SpecialCells(xlCellTypeV isible).Address -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Giff" wrote in message ... Does anyone know of a way to input the address of each cell in the visible range (I've been using ActiveWindow.VisibleRange as a test) into an array? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VisibleRange references | Excel Programming | |||
How unselect? Want to run ActiveWindow.VisibleRange but have Chartobject selected | Excel Programming | |||
load addresses of selected cells into array | Excel Programming | |||
ActiveWindow.VisibleRange.Width - Is this the correct code | Excel Programming | |||
array filling: cell addresses | Excel Programming |