Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone
I'm trying to find a way to loop on every area in a multiple selection and the help provided is rather concise ' **** Sub NoMultiAreaSelection( NumberOfSelectedAreas = Selection.Areas.Coun If NumberOfSelectedAreas 1 The MsgBox "You cannot carry out this command on multi-area selections End I End Su ' **** I would like to get some information like the area's address for each area in the current selection. Something like this **** Sub MultiAreaSelection( Dim NumberOfSelectedAreas As Integer, intI As Intege NumberOfSelectedAreas = Selection.Areas.Coun For intI = 1 To NumberOfSelectedArea 'How can I get each area's address, for example Next int End Su ' **** Another question about Selection Why, in VBA, when I type "Selection" followed by a dot, I do not get any option suggested. The same as when an object is declared as Object, a too general object Thanks to anyone who can help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
SUM of areas | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Print Areas | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions |