Hello!
have been looking around and can't get what I find to really work for me. Need help creating named ranges in VBA.
Data will be sorted by column A.
Data begins on row 2.
Would like for code to identify first instance of a value and the last instance of the value and create a range between them, and 3 columns over. Range name should equal value.
And for the code to work down the column.
Does that make sense?
Any help appreciated
have been looking around and can't get what I find to really work for me. Need help creating named ranges in VBA.
Data will be sorted by column A.
Data begins on row 2.
Would like for code to identify first instance of a value and the last instance of the value and create a range between them, and 3 columns over. Range name should equal value.
And for the code to work down the column.
Does that make sense?
Any help appreciated