I have been searching and can't find my answer on this.
I want to set a group of cells as a range. Here is my code.
I want to be able to use that set of data later in my code to set the values. I can use Selection.copy but it isn't as clean as using a range.
Thank you for your help!!
I want to set a group of cells as a range. Here is my code.
Code:
Sub test()
Dim dataset As Range
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
dataset = Selection
end sub
I want to be able to use that set of data later in my code to set the values. I can use Selection.copy but it isn't as clean as using a range.
Thank you for your help!!