Thanks! By using what you sand and a bunch of snippets of code I found online, I pieced this together. it doesn't quite work. Any suggestions?
(Code assums two things were selected for now)
Dim UpBound As Range
Dim LowBound As Range
Dim userSelections(1 To 10) As Range 'array that stores the...
For this macro, I'm trying to get it to work so that once a user selects multiple cells (A1, C3, F7, etc), the macro selects 100 cells below that so the range is (A1:A100, C1:C100, F1:F100). It does this for however many cells are selected.
This range then needs to be saved for some other use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.