Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Instead of always selecting every 20th row...I want VBA to prompt me
the quantity of rows. I think I can tell VBA to prompt the qty of rows I want to select instead of defaulting to 20. Here is the VBA string: Sub SelectEveryNthRow() ' Initialize ColsSelection equal to the number of columns in the ' selection. ColsSelection = Selection.Columns.Count ' Initialize RowsSelection equal to the number of rows in your ' selection. RowsSelection = Selection.Rows.Count ' Initialize RowsBetween equal to Twenty. RowsBetween = 20 ' Initialize Diff equal to one row less than the first row number of ' the selection. Diff = Selection.Row - 1 ' Resize the selection to be 1 column wide and the same number of ' rows long as the initial selection. Selection.Resize(RowsSelection, 1).Select ' Resize the selection to be every twentieth row and the same number of ' columns wide as the original selection. Set FinalRange = Selection. _ Offset(RowsBetween - 1, 0).Resize(1, ColsSelection) ' Loop through each cell in the selection. For Each xCell In Selection ' If the row number is a multiple of 3, then . . . If xCell.Row Mod RowsBetween = Diff Then ' ...reset FinalRange to include the union of the current ' FinalRange and the same number of columns. Set FinalRange = Application.Union _ (FinalRange, xCell.Resize(1, ColsSelection)) ' End check. End If ' Iterate loop. Next xCell ' Select the requested cells in the range. FinalRange.Select End Sub What can I change to make this adjustment? Thanks Brandon G. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |