|
-
Aug 23rd, 2005, 01:02 PM
#1
Thread Starter
Junior Member
[RESOLVED] Working with Selected Rows Only??
I'm trying to get my macro to act on the selected rows only, as compared to running through all rows from top to bottom. Is there a way to check the status of the row as the activecell moves down the spreadsheet? If not selected then go to next row and check again. THANKS.
For example:
Sub Loop_Selected_Rows()
Range("A1").Select
For x = 1 To NumRows
ActiveCell.Offset(1, 0).Activate
' I assumed using .select would unselect the selected rows. Not sure if activate would work
'If row is selected Then
' do stuff here
'End If
Next x
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|